Abomasnow — TCGNET

Active Listings

Database query walkthrough

Card active listings query

Asks for buyable listings for the exact card variant opened on the detail page.

Django path: frontend.services.catalog_service.list_active_listings_for_variant
Tables touched: MarketListing, InventoryItem, CardVariant, Card, CardGame, CardSet, CardImage, User

Use the selected card_variant_id from the detail URL as the lookup value.
Ask for listings whose InventoryItem points to that variant.
Filter to ACTIVE listings with quantity_available greater than zero.
Ask for seller and card metadata rows through the listing relationship.
Order by lowest unit price first, then id for stable buy options.

ORM shape

MarketListing.objects.filter(
    inventory_item__card_variant_id=variant_id,
    status=ACTIVE,
    quantity_available__gt=0,
).select_related(...).order_by('unit_price', 'id')

📭

No active listings for this card right now.

Price History

Database query walkthrough

Price history query

Asks for the newest stored price snapshots for the exact card variant.

Django path: frontend.services.catalog_service.build_price_history
Tables touched: PriceSnapshot, CardVariant

Use the current card variant id from the detail card data.
Ask for PriceSnapshot rows with that card_variant_id.
Order snapshots by newest captured_at value, then newest id for stable results.
Limit the answer to the 24 newest snapshots.
Read date, price, and source name from the returned rows.

ORM shape

PriceSnapshot.objects.filter(card_variant_id=variant_id)
    .order_by('-captured_at', '-id')[:24]

Date	Price	Source
April 23, 2026	$37.00	marketplace_sale

Similar Cards

Database query walkthrough

Similar cards query

Asks for nearby catalog variants using simple database metadata.

Django path: frontend.services.catalog_service.list_similar_cards
Tables touched: CardVariant, Card, CardGame, CardSet, CardImage

Use the opened card's game and rarity as the similarity criteria.
Ask for CardVariant rows with the same game and rarity.
Filter out rows that belong to the currently opened Card id.
Ask for related card, game, set, and image data through the variant relationship.
Order by card name and id, then limit the answer to six cards.

ORM shape

CardVariant.objects.select_related(...)
    .filter(card__game__name=card['game'], rarity=card['rarity'])
    .exclude(card_id=card['id'])
    .order_by('card__name', 'id')[:6]