| q462 |
R-SET |
NOT_EQUAL |
multiplicity |
|
What's the Italian name of the set of cards with "Ancestor's Chosen" is in? |
| q340 |
|
ERROR |
|
|
prediction: statement: the text does not parse: Invalid expression / Unexpected token. Line 1, Col: 8. SELECT [4m\[0m* FROM cards WHERE cardKingdomFoilId IS NOT NULL AND cardKingdomId IS NOT NULL; |
| q347 |
|
ERROR |
|
|
prediction: execute: execute: ambiguous column name: id |
| q349 |
|
ERROR |
|
|
prediction: statement: the text does not parse: Invalid expression / Unexpected token. Line 1, Col: 51. SELECT c.name, c.artist, MAX(COUNT(r.uuid)) as max[4m\[0m_ruling\_info FROM cards c JOIN rulings r ON c.uuid = r.uuid WHERE c.isPromo = 1 GROUP BY c.name, c. |
| q352 |
|
ERROR |
|
|
prediction: statement: 2 statements in one text; an audit runs one |
| q358 |
|
ERROR |
|
|
prediction: statement: the text does not parse: Error tokenizing 'olor FROM cards WHERE name = 'Ancestor\'s Chosen'' |
| q366 |
|
ERROR |
|
|
prediction: statement: the text does not parse: Error tokenizing 'ards.uuid WHERE cards.name = 'Benalish Knight'; ``' |
| q368 |
|
ERROR |
|
|
prediction: execute: execute: incomplete input |
| q371 |
|
ERROR |
|
|
prediction: statement: the text does not parse: Invalid expression / Unexpected token. Line 12, Col: 12. UNT(*) FROM cards WHERE isStorySpotlight = 1), 2) AS percentage FROM cards LIMIT 1; Explanation[4m:[0m 1. Count the number of Story Spotlight cards: SELECT COUNT(*) FROM cards WHERE isStorySpotligh |
| q377 |
|
ERROR |
|
|
prediction: statement: 2 statements in one text; an audit runs one |
| q397 |
|
ERROR |
|
|
prediction: execute: execute: no such column: sets.frameVersion |
| q402 |
|
ERROR |
|
|
prediction: execute: execute: incomplete input |
| q407 |
|
ERROR |
|
|
prediction: statement: the text does not parse: Invalid expression / Unexpected token. Line 3, Col: 9. SELECT DISTINCT types FROM cards JOIN set[4m\[0m_translations ON cards.setCode = set\_translations.setCode WHERE set\_translations.language = 'Germa |
| q412 |
|
ERROR |
|
|
prediction: statement: the text does not parse: Invalid expression / Unexpected token. Line 1, Col: 15. SELECT foreign[4m\[0m_data.name FROM foreign\_data JOIN cards ON foreign\_data.uuid = cards.uuid WHERE foreign\_data.lang |
| q415 |
|
ERROR |
|
|
prediction: statement: the text does not parse: Error tokenizing ' c.format = 'commander' AND l.status = 'legal'; ``' |
| q416 |
|
ERROR |
|
|
prediction: execute: execute: incomplete input |
| q440 |
|
ERROR |
|
|
prediction: statement: the text does not parse: Invalid expression / Unexpected token. Line 2, Col: 9. SELECT language FROM set[4m\[0m_translations JOIN sets ON set\_translations.setCode = sets.code JOIN cards ON sets.code = cards.set |
| q459 |
|
ERROR |
|
|
prediction: statement: the text does not parse: Invalid expression / Unexpected token. Line 7, Col: 14. E c1.name IN ('Serra Angel', 'Shrine Keeper') ORDER BY c1.convertedManaCost DESC LIMIT 1; This SQL [4mquery[0m will return the name and converted mana cost of the card with the higher converted mana cost betwee |
| q466 |
|
ERROR |
|
|
prediction: execute: execute: no such column: foreign_data.artist |
| q473 |
|
ERROR |
|
|
prediction: statement: the text does not parse: Invalid expression / Unexpected token. Line 6, Col: 14. FROM sets JOIN cards ON sets.code = cards.setCode WHERE cards.name = 'Adarkar Valkyrie'; This SQL [4mquery[0m will return the value of the `isForeignOnly` column from the `sets` table for the set containing th |
| q477 |
|
ERROR |
|
|
prediction: statement: 2 statements in one text; an audit runs one |
| q480 |
|
ERROR |
|
|
prediction: statement: the text does not parse: Error tokenizing 'hosen' AND set\_translations.language = 'Italian'' |
| q483 |
|
ERROR |
|
|
prediction: execute: execute: no such column: set_translations.language |
| q484 |
|
ERROR |
|
|
prediction: statement: the text does not parse: Invalid expression / Unexpected token. Line 1, Col: 15. SELECT foreign[4m\[0m_data.name FROM foreign\_data JOIN cards ON foreign\_data.uuid = cards.uuid JOIN sets ON cards.setCo |
| q486 |
|
ERROR |
|
|
prediction: statement: the text does not parse: Invalid expression / Unexpected token. Line 4, Col: 12. e 0 end) / SUM(case when name = 'Coldsnap' then 1 else 0 end) as percentage FROM cards; Explanation[4m:[0m 1. We need to find the percentage of cards with a converted mana cost of 7 in the set Coldsnap. 2. |
| q487 |
|
ERROR |
|
|
prediction: execute: execute: incomplete input |
| q518 |
|
ERROR |
|
|
gold: execute: execute: the statement ran past its 30s timeout |
| q528 |
|
ERROR |
|
|
prediction: statement: the text does not parse: Error tokenizing 's WHERE legalities.uuid = cards.uuid) = 'Legal' ``' |
| q529 |
|
ERROR |
|
|
prediction: statement: the text does not parse: Invalid expression / Unexpected token. Line 3, Col: 9. SELECT sets.name FROM sets JOIN set[4m\[0m_translations ON sets.code = set\_translations.setCode WHERE sets.name NOT LIKE '%Japanese%' AND set |
| q530 |
|
ERROR |
|
|
prediction: statement: the text does not parse: Invalid expression / Unexpected token. Line 1, Col: 38. SELECT DISTINCT frameVersion AS frame[4m\[0m_style FROM cards; SELECT DISTINCT artist AS allen\_williams\_cards FROM cards WHERE artist = 'Alle |