List of International Cards/IT/Mount Doom/Foil
 Italian Set 9 - REF
|
 Back to Italian Card Index |
Italian Set 11 - SH 
|
Use the link below each card image to see the main article for that card, or click/tap on the card image to go straight to the upload page to replace it with a new image.
If you have physical proof (i.e. a photo) of a card that is not listed below, please contact ketura on the PC Discord ASAP.
Card Images[edit]
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`,`C`.`Title`) AS `Title`,IFNULL(`CR`.`Subtitle`,`C`.`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 CONCAT(`L`.`Code`, ' Rare Foil') WHEN `CR`.`Subset` = 'O' THEN CONCAT(`L`.`Code`, ' Masterworks Foil') ELSE CONCAT(`L`.`Code`, ' Foil') 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 (`CR`.`LanguageCode` IN (IT) OR ((('EN' IN (IT) AND `CR`.`LanguageCode` IN ('TW')) OR ('DE' IN (IT) AND `CR`.`LanguageCode` IN ('TG'))) AND CASE WHEN `C`.`SetNum` RLIKE '^-?[0-9]+$' THEN CAST(`C`.`SetNum` AS UNSIGNED INTEGER) ELSE 0 END > 10)) AND (`CR`.`Subset` IN ('F', 'A', 'O') OR (`CR`.`Subset` = 'G' AND `C`.`SetNum` != '15')) AND `C`.`SetNum` = '10' 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` DESC,`L`.`Code` LIMIT 100
