← Back to Catalog

Lopunny

RARE Pokemon

Lopunny

Estimated Value $0.00

Set Flashfire

Language en

Rarity RARE

Edition Standard

Login to Buy

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')

Seller	Condition	Qty Available	Price / Unit
randomaccount2123	MINT	1	$40.00	Login

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]

📊

No price history available yet.

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]

Abomasnow

Forbidden Light

Abomasnow

Abomasnow

Abomasnow

Mysterious Treasures

Abomasnow

Abomasnow