TCGNET

Buy & Sell
Rare Cards

Discover thousands of cards, manage your collection, and trade with collectors worldwide.

Waiting for this month's first sale

Charizard

Database query walkthrough

Monthly top sale query

Asks for the highest unit-price completed sale from the current calendar month.

Django path: frontend.services.catalog_service.get_most_expensive_card_sold_this_month
Tables touched: PurchaseOrderLine, PurchaseOrder, CardVariant, Card, CardGame, CardSet, CardImage

Define the month window with a start timestamp and an exclusive next-month timestamp.
Ask for purchase order lines whose orders are completed inside that month window.
Ask for the related order, card, game, set, and image rows in the same query path.
Order matching rows by highest unit price, newest purchase time, and newest line id.
Read the first matching row as the monthly top sale.

ORM shape

PurchaseOrderLine.objects.filter(
    purchase_order__status=COMPLETED,
    purchase_order__created_at__gte=month_start,
    purchase_order__created_at__lt=next_month_start,
).select_related(...).order_by(
    '-unit_price', '-purchase_order__created_at', '-id'
).first()

Base Set / RARE

Latest Listings

Database query walkthrough

Latest listings query

Asks for the newest active marketplace listings that still have stock available.

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

Ask for MarketListing rows with ACTIVE status and quantity_available greater than zero.
Ask for seller, inventory item, card variant, card, game, set, and image rows through the listing relationship.
Apply any search or filter parameters supplied by the browsing surface.
Order listings by newest created_at value, then id for stable results.
Limit the answer to the six rows displayed on the home page.

ORM shape

MarketListing.objects.filter(
    status=ACTIVE,
    quantity_available__gt=0,
).select_related(...).order_by('-created_at', 'id')[:6]

Browse all →

Pikachu

$27.82 × 1 available

Listed by PokemonPro

Charizard

$50000.00 × 1 available

Listed by Inventure71

Accelgor

$1.55 × 1 available

Listed by PokemonPro

Light Vaporeon

$69.00 × 1 available

Listed by PokemonPro

Absol

$42.00 × 1 available

Listed by PokemonPro

Ponyta

$1.30 × 1 available

Listed by randomaccount2123

Featured Cards

Database query walkthrough

Featured cards query

Asks for this month's top sold variants and any fallback catalog variants needed for the display.

Django path: frontend.services.catalog_service.list_top_sold_cards_this_month
Tables touched: PurchaseOrderLine, PurchaseOrder, CardVariant, Card, CardGame, CardSet, CardImage

Ask for purchase order lines whose orders are completed inside the current calendar month.
Group the matching rows by card_variant_id.
Ask SQL to calculate total quantity sold and total sales value for each variant group.
Order variant groups by most units sold, highest sales value, and card_variant_id.
If the sales answer has fewer than six variants, ask CardVariant for the remaining display slots.
Filter fallback variants so already-selected sale variants are not repeated.
Read the selected CardVariant rows in display priority order.

ORM shape

PurchaseOrderLine.objects.filter(...).values('card_variant_id')
    .annotate(sold_quantity=Sum('quantity'), sales_total=Sum(quantity * unit_price))
    .order_by('-sold_quantity', '-sales_total', 'card_variant_id')[:6]
CardVariant.objects.exclude(pk__in=sold_ids)
    .order_by('-current_value', 'card__name', 'id')[:missing_slots]

View all →

Charizard

Base Set

RARE $112333.33