Skip to content

Instantly share code, notes, and snippets.

@Phara0h
Last active November 24, 2019 13:33
Show Gist options
  • Save Phara0h/93d07f7f232ddc79f4813eb6b9a927f1 to your computer and use it in GitHub Desktop.
Save Phara0h/93d07f7f232ddc79f4813eb6b9a927f1 to your computer and use it in GitHub Desktop.
SELECT DISTINCT data_names.name AS card_name,
quantity AS amount,
multiverseid,
foil AS is_foil,
data_editions.name AS set_name
FROM cards, data_cards, data_names, data_editions
WHERE cards.card == data_cards._id
AND data_cards.name = data_names._id
AND data_cards.edition = data_editions._id;
@multimeric
Copy link

Unfortunately they seem to have removed most of those tables above, so this doesn't work anymore. All it has now is:
android_metadata, cards, delverlens, and lists

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment