![]() ![]() GROUP_CONCAT(CASE WHEN u.position = 1 THEN name_ascii ELSE '' END SEPARATOR '') starter ELSE NULL END) AS starter, SUM(CASE WHEN u.position = 1 OR ( u.position = 2 AND u.layout = 'meld') THEN u. life ELSE NULL END) AS life, SUM(CASE WHEN u.position = 1 OR ( u.position = 2 AND u.layout = 'meld') THEN u. ![]() hand ELSE NULL END) AS hand, SUM(CASE WHEN u.position = 1 OR ( u.position = 2 AND u.layout = 'meld') THEN u. image_name ELSE '' END SEPARATOR '') AS image_name, SUM(CASE WHEN u.position = 1 OR ( u.position = 2 AND u.layout = 'meld') THEN u. ') AS search_text, GROUP_CONCAT(CASE WHEN u.position = 1 THEN u. GROUP_CONCAT(CASE WHEN `u`.position = 1 THEN type ELSE '' END SEPARATOR '')ĪS type, GROUP_CONCAT(`u`.`text` SEPARATOR ' GROUP_CONCAT(CASE WHEN `u`.position = 1 OR `u`.position = 2 THEN type ELSE '' END SEPARATOR '') SUM(CASE WHEN `u`.position = 1 THEN `u`.cmc ELSE 0 END)ĪS cmc, GROUP_CONCAT(CASE WHEN `u`.position = 1 THEN `u`.`power` ELSE '' END SEPARATOR '') AS `power`, GROUP_CONCAT(CASE WHEN `u`.position = 1 THEN `u`.`toughness` ELSE '' END SEPARATOR '') AS `toughness`, GROUP_CONCAT(CASE WHEN `u`.position = 1 THEN `u`.`loyalty` ELSE '' END SEPARATOR '') AS `loyalty`, SUM(CASE WHEN `u`.position = 1 OR `u`.position = 2 THEN cmc ELSE 0 END) WHEN layout = 'split' OR layout = 'aftermath' THEN GROUP_CONCAT(`u`.`mana_cost` SEPARATOR '|') GROUP_CONCAT(CASE WHEN `u`.position = 1 THEN mana_cost ELSE '' END SEPARATOR '') GROUP_CONCAT(face_name SEPARATOR ' // ' ) GROUP_CONCAT(CASE WHEN `u`.position = 1 OR `u`.position = 2 THEN face_name ELSE '' END SEPARATOR '') GROUP_CONCAT(CASE WHEN `u`.position = 1 THEN face_name ELSE '' END SEPARATOR '') ![]() WHEN layout = 'double-faced' OR layout = 'flip' THEN ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |