Template:CardList
Function: CargoSQLQuery::run Query: SELECT `L`.`_pageID` AS `cargo_backlink_page_id_L`,`CR`.`_pageID` AS `cargo_backlink_page_id_CR`,`C`.`_pageID` AS `cargo_backlink_page_id_C`,`CR`.`ImageFilename` AS `ImageFile`,REPLACE(REPLACE(`C`.`_pageName`, '/Data', ), 'Data:', ) AS `PageTitle`,IFNULL(`CR`.`Title`,ECR.Title) AS `Title`,IFNULL(`CR`.`Subtitle`,ECR.Subtitle) AS `Subtitle`,IFNULL(`CR`.`CollInfo`,`C`.`CollInfo`) AS `CollInfo`,CONCAT(CASE WHEN `L`.`Code` = 'TW' THEN 'EN Tengwar Foil' WHEN `L`.`Code` = 'TG' THEN 'DE Tengwar Foil' ELSE CASE WHEN `CR`.`Subset` = 'A' THEN 'Rare Foil' WHEN `CR`.`Subset` = 'O' THEN 'Masterworks Foil' ELSE CONCAT('EN', ' Card') END END) AS `Suffix` FROM `cargo__Cards` `C` LEFT OUTER JOIN `cargo__CardReleases` `CR` ON ((`C`.`ID`=`CR`.`BaseCardID`)) LEFT OUTER JOIN `cargo__Languages` `L` ON ((`CR`.`LanguageCode`=`L`.`Code`)) WHERE (`L`.`Code` IN ('EN')) AND (`CR`.`Subset` IN ('S') OR (`CR`.`Subset` = 'G' AND `C`.`SetNum` != '15')) AND `C`.`SetNum` = '{{{SetNum}}}' ORDER BY CASE WHEN `C`.`SetNum` = '0' THEN 20 ELSE CASE WHEN `C`.`SetNum` RLIKE '^-?[0-9]+$' THEN CAST(`C`.`SetNum` AS UNSIGNED INTEGER) ELSE 100 END END,CASE WHEN `C`.`SetNum` = '0' THEN CASE WHEN `C`.`Subset` IN ('S', 'F') THEN 1 WHEN `C`.`Subset` IN ('D', 'L') THEN 2 WHEN `C`.`Subset` = 'M' THEN 3 WHEN `C`.`Subset` = 'J' THEN 4 ELSE 20 END ELSE CASE WHEN `C`.`Subset` = 'S' THEN 0 WHEN `C`.`Subset` = 'F' THEN 1 WHEN `C`.`Subset` = 'M' THEN 2 WHEN `C`.`Subset` = 'A' THEN 3 WHEN `C`.`Subset` = 'O' THEN 4 WHEN `C`.`Subset` = 'T' THEN 5 END END,`C`.`CardNum`,`CR`.`Revision`,`L`.`Code` LIMIT 100
