') AS search_text, GROUP_CONCAT(CASE WHEN u.position = 1 THEN u.image_name ELSE '' END SEPARATOR '') AS image_name, GROUP_CONCAT(CASE WHEN u.position = 1 THEN u.hand ELSE '' END SEPARATOR '') AS hand, GROUP_CONCAT(CASE WHEN u.position = 1 THEN u.life ELSE '' END SEPARATOR '') AS life, GROUP_CONCAT(CASE WHEN u.position = 1 THEN u.starter ELSE '' END SEPARATOR '') AS starter, GROUP_CONCAT(CASE WHEN u.position = 1 THEN u.position ELSE '' END SEPARATOR '') AS position, ') AS text, GROUP_CONCAT(u.search_text SEPARATOR ' Failed to execute INSERT INTO card_legality (format_id, card_id, legality) SELECT 34, bq.id, 'Legal' FROM ( SELECTu.idASid,u.layoutASlayout,u.idAS face_id, CASE WHEN layout = 'double-faced' OR layout = 'flip' THEN GROUP_CONCAT(CASE WHENu.position = 1 THEN face_name ELSE '' END SEPARATOR '') WHEN layout = 'meld' THEN GROUP_CONCAT(CASE WHENu.position = 1 ORu.position = 2 THEN face_name ELSE '' END SEPARATOR '') ELSE GROUP_CONCAT(face_name SEPARATOR ' // ' ) END AS name, GROUP_CONCAT(u.mana_costSEPARATOR '|') ASmana_cost, CASE WHEN layout = 'split' OR layout = 'aftermath' THEN SUM(u.cmc) WHEN layout = 'meld' THEN SUM(CASE WHENu.position = 1 ORu.position = 2 THEN cmc ELSE 0 END) ELSE SUM(CASE WHENu.position = 1 THENu.cmc ELSE 0 END) END AS cmc, GROUP_CONCAT(CASE WHENu.position = 1 THENu.powerELSE '' END SEPARATOR '') ASpower, GROUP_CONCAT(CASE WHENu.position = 1 THENu.toughnessELSE '' END SEPARATOR '') AStoughness, GROUP_CONCAT(CASE WHENu.position = 1 THENu.loyaltyELSE '' END SEPARATOR '') ASloyalty, CASE WHEN layout = 'meld' THEN GROUP_CONCAT(CASE WHENu.position = 1 ORu.position = 2 THEN type ELSE '' END SEPARATOR '') ELSE GROUP_CONCAT(CASE WHENu.position = 1 THEN type ELSE '' END SEPARATOR '') END AS type, GROUP_CONCAT(u.text` SEPARATOR '
0 kommentar(er)
