card_games Database Schema

SQL Query:

SELECT T1.uuid, T3.language FROM cards AS T1 INNER JOIN legalities AS T2 ON T1.uuid = T2.uuid INNER JOIN foreign_data AS T3 ON T1.uuid = T3.uuid WHERE T2.format = 'legacy'

Evidence:

legacy card refers to format = 'legacy'; foreign language refers to language in foreign_data

SQL Query:

SELECT id FROM cards WHERE convertedManaCost = 0

Evidence:

converted mana cost of 0 refers to covertedManaCost = 0;

SQL Query:

SELECT COUNT(T1.id) FROM sets AS T1 INNER JOIN set_translations AS T2 ON T2.setCode = T1.code WHERE T2.translation IS NOT NULL AND T1.baseSetSize < 100 AND T2.language = 'Italian'

Evidence:

Italian translation refers to language = 'Italian'; have a translation means translation is not null; base set number of under 100 refers to baseSetSize < 10

SQL Query:

SELECT T2.setCode FROM sets AS T1 INNER JOIN set_translations AS T2 ON T2.setCode = T1.code WHERE T1.releaseDate = '2007-07-13'

SQL Query:

SELECT id, language FROM set_translations WHERE id = ( SELECT id FROM cards WHERE convertedManaCost = 5 ) AND setCode = '10E'

Evidence:

set 10E refers to setCode = '10E'; converted mana of 5 refers to convertedManaCost = 5;