Template:CardList: Difference between revisions
No edit summary |
No edit summary |
||
| Line 3: | Line 3: | ||
|fields= CR.ImageFilename=ImageFile | |fields= CR.ImageFilename=ImageFile | ||
,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle | ,REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', '')=PageTitle | ||
,IFNULL(CR.Title,ECR.Title)=Title | |||
, IFNULL(CR.Subtitle,ECR.Subtitle)=Subtitle | |||
, IFNULL(CR.CollInfo,C.CollInfo)=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({{{Lang|'EN'}}}, ' Card') END END)=Suffix | ,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({{{Lang|'EN'}}}, ' Card') END END)=Suffix | ||
|where=(L.Code IN ({{{Lang|'EN'}}})) AND (CR.Subset IN ('S') OR (CR.Subset = 'G' AND C.SetNum != '15')) AND C.SetNum = '{{{SetNum}}}' | |where=(L.Code IN ({{{Lang|'EN'}}})) AND (CR.Subset IN ('S') OR (CR.Subset = 'G' AND C.SetNum != '15')) AND C.SetNum = '{{{SetNum}}}' | ||
Revision as of 08:13, 15 April 2022
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
