search

richardspirit / mtga_stats

Originated as way to manage Magic The Gathering decks on MGTA so that I knew which decks were performing the best and which decks should be deleted.
GNU Lesser General Public License v3.0
1 stars 0 forks source link

Card totals incorrect #39

Closed richardspirit closed 3 years ago

richardspirit commented 3 years ago

Some of the card totals are not adding up to the card total column, could be missing a Types value.

ex. Total Land Spell Creatures Control Center 60 25 18 16

richardspirit commented 3 years ago

Is Related to Double sided/multiple types cards.

richardspirit commented 3 years ago

select distinct card_name, types,set_code,set_name from mtga.sets s where card_name like ('Hengegate Pathway%') or card_name like ('Makindi Stampede%')