Card Catalog

Database query walkthrough

Catalog browser query

Asks for filtered card variants, paginated card rows, and grouped book/shelf summaries.

Django path
frontend.services.catalog_service.list_card_page + list_catalog_set_summaries
Tables touched
CardVariant, Card, CardGame, CardSet, CardImage, MarketListing
  1. Ask from CardVariant rows because each result represents an exact printing.
  2. Ask for related Card, CardGame, CardSet, and CardImage rows through the variant relationship.
  3. Apply sidebar filters in SQL: trigram identity search plus game, set, rarity, language, and value range.
  4. When Only available is checked, ask EXISTS whether the same variant has an active listing with available quantity.
  5. For card view, apply the selected sort order and ask for only the current page with LIMIT and OFFSET.
  6. For book and shelf views, ask GROUP BY queries to calculate Count and Sum totals per set or game.
  7. Ask PostgreSQL DISTINCT ON for one ordered cover card per book or shelf.
ORM shape 
CardVariant.objects.select_related('card__game', 'set', 'image')
    .annotate(search_rank=Greatest(TrigramSimilarity(...)))
    .filter(search_rank__gt=0.1)
    .annotate(has_active_listing=Exists(MarketListing.objects.filter(...)))
    .order_by(...)
    # Paginator applies LIMIT/OFFSET for card view
queryset.values('set_id', 'set__name').annotate(Count('id'), Sum('current_value'))
queryset.order_by('set_id', ...).distinct('set_id')

Browse 2459 cards across all sets and games.

Card Collection Book Cover Shelf
13139 results
Ampharos-EX
Ancient Origins Pokemon · 82 cards $0.00
Aipom
Aquapolis Pokemon · 152 cards $0.00
Aerodactyl
Arceus Pokemon · 99 cards $0.00
Absol
Astral Radiance Pokemon · 167 cards $0.00
Abomasnow
Astral Radiance Trainer Gallery Pokemon · 25 cards $0.00
Aegislash
BREAKpoint Pokemon · 99 cards $0.00
Abomasnow
BREAKthrough Pokemon · 136 cards $0.00
Altaria
BW Black Star Promos Pokemon · 93 cards $0.00
Abra
Base Set Pokemon · 69 cards $112348.89
Abra
Base Set 2 Pokemon · 100 cards $200.00
Aegislash
Battle Styles Pokemon · 146 cards $0.00
Dark Ivysaur
Best of Game Pokemon · 8 cards $0.00
Alomomola
Black & White Pokemon · 94 cards $0.00
Altaria
Boundaries Crossed Pokemon · 135 cards $0.00
Aggron V
Brilliant Stars Pokemon · 151 cards $89.69
Alcremie
Brilliant Stars Trainer Gallery Pokemon · 25 cards $0.00
Alolan Grimer
Burning Shadows Pokemon · 142 cards $0.00
Ampharos
Call of Legends Pokemon · 86 cards $0.00
Cosmoem
Celebrations Pokemon · 23 cards $0.00
Blastoise
Celebrations: Classic Collection Pokemon · 22 cards $0.00
Alolan Raticate-GX
Celestial Storm Pokemon · 142 cards $0.00
Absol
Champion's Path Pokemon · 57 cards $0.00
Abomasnow
Chilling Reign Pokemon · 168 cards $0.00
Absol
Cosmic Eclipse Pokemon · 229 cards $16.00
Accelgor
Crimson Invasion Pokemon · 108 cards $0.00
Aggron ex
Crystal Guardians Pokemon · 82 cards $0.00
Arceus
DP Black Star Promos Pokemon · 51 cards $0.00
Accelgor
Dark Explorers Pokemon · 98 cards $0.00
Accelgor
Darkness Ablaze Pokemon · 172 cards $0.00
Azumarill
Delta Species Pokemon · 95 cards $0.00
Altaria
Deoxys Pokemon · 96 cards $0.00
Arcanine
Detective Pikachu Pokemon · 18 cards $0.00
Azumarill
Diamond & Pearl Pokemon · 107 cards $8.00
Team Aqua's Carvanha
Double Crisis Pokemon · 22 cards $0.00
Absol
Dragon Pokemon · 93 cards $0.00
Altaria ex δ
Dragon Frontiers Pokemon · 83 cards $0.00
Altaria
Dragon Majesty Pokemon · 67 cards $0.00
Axew
Dragon Vault Pokemon · 18 cards $0.00
Aggron
Dragons Exalted Pokemon · 122 cards $420.00
Arcanine
EX Trainer Kit 2 Minun Pokemon · 7 cards $0.00
Beldum
EX Trainer Kit 2 Plusle Pokemon · 7 cards $0.00
Bagon
EX Trainer Kit Latias Pokemon · 7 cards $0.00
Electrike
EX Trainer Kit Latios Pokemon · 7 cards $0.00
Altaria ex
Emerald Pokemon · 86 cards $0.00
Audino
Emerging Powers Pokemon · 91 cards $0.00
Arcanine
Evolutions Pokemon · 79 cards $0.00
Altaria
Evolving Skies Pokemon · 193 cards $0.00
Abra
Expedition Base Set Pokemon · 136 cards $0.00
Aerodactyl
Fates Collide Pokemon · 95 cards $30.00
Arcanine
FireRed & LeafGreen Pokemon · 99 cards $0.00
Avalugg
Flashfire Pokemon · 94 cards $0.00
Abomasnow
Forbidden Light Pokemon · 120 cards $23.60
Aerodactyl
Fossil Pokemon · 57 cards $0.00
Accelgor
Furious Fists Pokemon · 94 cards $0.00
Absol
Fusion Strike Pokemon · 245 cards $0.00
Altaria
Generations Pokemon · 89 cards $0.00
Altaria
Great Encounters Pokemon · 100 cards $0.00
Absol
Guardians Rising Pokemon · 148 cards $0.00
Blaine's Arcanine
Gym Challenge Pokemon · 95 cards $0.00
Blaine's Charmander
Gym Heroes Pokemon · 91 cards $0.00
Cleffa
HGSS Black Star Promos Pokemon · 24 cards $0.00
Absol
HS—Triumphant Pokemon · 96 cards $0.00
Aron
HS—Undaunted Pokemon · 80 cards $0.00
Aipom
HS—Unleashed Pokemon · 82 cards $0.00
Ampharos
HeartGold & SoulSilver Pokemon · 99 cards $0.00
Arbok
Hidden Fates Pokemon · 52 cards $0.00
Baltoy
Hidden Legends Pokemon · 93 cards $0.00
Absol
Holon Phantoms Pokemon · 91 cards $0.00
Bellsprout
Jungle Pokemon · 63 cards $0.00
Bidoof
Kalos Starter Set Pokemon · 33 cards $0.00
Absol
Legend Maker Pokemon · 82 cards $0.00
Abra
Legendary Collection Pokemon · 99 cards $0.00
Altaria
Legendary Treasures Pokemon · 134 cards $0.00
Anorith
Legends Awakened Pokemon · 135 cards $0.00
Abomasnow
Lost Origin Pokemon · 177 cards $37.00
Banette
Lost Origin Trainer Gallery Pokemon · 24 cards $0.00
Alolan Diglett
Lost Thunder Pokemon · 192 cards $0.00
Aerodactyl
Majestic Dawn Pokemon · 82 cards $0.00
Alomomola
McDonald's Collection 2011 Pokemon · 12 cards $0.00
Axew
McDonald's Collection 2012 Pokemon · 12 cards $0.00
Bunnelby
McDonald's Collection 2014 Pokemon · 12 cards $0.00
Electrike
McDonald's Collection 2015 Pokemon · 12 cards $0.00
Dedenne
McDonald's Collection 2016 Pokemon · 12 cards $0.00
Alolan Diglett
McDonald's Collection 2017 Pokemon · 12 cards $0.00
Chansey
McDonald's Collection 2018 Pokemon · 12 cards $0.00
Alolan Dugtrio
McDonald's Collection 2019 Pokemon · 12 cards $0.00
Bulbasaur
McDonald's Collection 2021 Pokemon · 25 cards $0.00
Bewear
McDonald's Collection 2022 Pokemon · 15 cards $0.00
Abomasnow
Mysterious Treasures Pokemon · 111 cards $0.00
Chansey
Neo Destiny Pokemon · 98 cards $69.00
Beedrill
Neo Discovery Pokemon · 71 cards $0.00
Aipom
Neo Genesis Pokemon · 81 cards $0.00
Aerodactyl
Neo Revelation Pokemon · 61 cards $0.00
Amoonguss
Next Destinies Pokemon · 95 cards $0.00
Articuno ex
Nintendo Black Star Promos Pokemon · 36 cards $0.00
Accelgor
Noble Victories Pokemon · 94 cards $0.00
Armaldo ex
POP Series 1 Pokemon · 17 cards $0.00
Bulbasaur
POP Series 2 Pokemon · 13 cards $0.00
Blastoise
POP Series 3 Pokemon · 15 cards $0.00
Chimecho δ
POP Series 4 Pokemon · 14 cards $0.00
Charmander δ
POP Series 5 Pokemon · 12 cards $0.00
Bastiodon
POP Series 6 Pokemon · 17 cards $0.00
Ampharos
POP Series 7 Pokemon · 17 cards $0.00
Carnivine
POP Series 8 Pokemon · 14 cards $0.00
Buizel
POP Series 9 Pokemon · 17 cards $0.00
Aegislash-EX
Phantom Forces Pokemon · 99 cards $0.00
Abomasnow
Plasma Blast Pokemon · 85 cards $1.60
Absol
Plasma Freeze Pokemon · 108 cards $0.00
Amoonguss
Plasma Storm Pokemon · 122 cards $0.00
Altaria
Platinum Pokemon · 115 cards $0.00
Eevee on the Ball
Pokémon Futsal Collection Pokemon · 5 cards $0.00
Aipom
Pokémon GO Pokemon · 74 cards $0.00
Bastiodon
Pokémon Rumble Pokemon · 16 cards $0.00
Absol ex
Power Keepers Pokemon · 81 cards $0.00
Aegislash
Primal Clash Pokemon · 133 cards $0.00
Abomasnow
Rebel Clash Pokemon · 176 cards $0.00
Aerodactyl GL
Rising Rivals Pokemon · 104 cards $20.00
Absol
Roaring Skies Pokemon · 92 cards $0.00
Aggron
Ruby & Sapphire Pokemon · 87 cards $0.00
Aipom
SM Black Star Promos Pokemon · 247 cards $0.00
Alakazam V
SWSH Black Star Promos Pokemon · 269 cards $0.00
Aerodactyl ex
Sandstorm Pokemon · 92 cards $0.00
Absol
Secret Wonders Pokemon · 120 cards $0.00
Alcremie V
Shining Fates Pokemon · 58 cards $0.00
Arbok
Shining Legends Pokemon · 66 cards $0.00
Alcremie
Shiny Vault Pokemon · 206 cards $0.00
Alolan Vulpix V
Silver Tempest Pokemon · 177 cards $0.00
Altaria
Silver Tempest Trainer Gallery Pokemon · 24 cards $0.00
Abra
Skyridge Pokemon · 156 cards $0.00
Butterfree
Southern Islands Pokemon · 18 cards $0.00
Aipom
Steam Siege Pokemon · 98 cards $0.00
Abomasnow
Stormfront Pokemon · 92 cards $0.00
Alolan Diglett
Sun & Moon Pokemon · 130 cards $0.00
Absol G
Supreme Victors Pokemon · 146 cards $15.00
Baltoy
Sword & Shield Pokemon · 173 cards $0.00
Absol
Team Magma vs Team Aqua Pokemon · 77 cards $40.00
Abra
Team Rocket Pokemon · 68 cards $0.00
Azumarill
Team Rocket Returns Pokemon · 97 cards $0.00
Absol
Team Up Pokemon · 155 cards $0.00
Abomasnow
Ultra Prism Pokemon · 137 cards $0.00
Aggron
Unbroken Bonds Pokemon · 196 cards $0.00
Abomasnow
Unified Minds Pokemon · 216 cards $0.00
Aipom
Unseen Forces Pokemon · 124 cards $0.00
Aegislash V
Vivid Voltage Pokemon · 166 cards $0.00
Arcanine
Wizards Black Star Promos Pokemon · 49 cards $0.00
Aegislash
XY Pokemon · 120 cards $0.00
Absol
XY Black Star Promos Pokemon · 186 cards $120.00