Warg
Warg
Warg is, in The Lord of the Rings, a wolf enhanced and twisted by dark powers. While warg does not appear as a race in the Lord of the Rings Trading Card Game, wargs make debuts as mounts for the 
Isengard and 
Orc cultures.
Function: CargoSQLQuery::run Query: SELECT `CR`.`_pageID` AS `cargo_backlink_page_id_CR`,`C`.`_pageID` AS `cargo_backlink_page_id_C`,`CR`.`ID` AS `CardID`,IFNULL(IFNULL(`CR`.`FormattedGameText`, `CR`.`GameText`),) AS `GameText`,`C`.`Subset` AS `Subset`,REPLACE(REPLACE(`C`.`_pageName`, '/Data', ), 'Data:', ) AS `PageTitle`,IFNULL(`CR`.`ImageFilename`,'File:Card_Not_Found.jpg') AS `ImageFile`,IFNULL(`CR`.`PortraitFilename`,'File:Portrait_Not_Found.jpg') AS `PortraitFile`,`C`.`Culture` AS `Culture`,`C`.`CardType` AS `CardType`,`Subtypes__full` AS `CardSubtype`,`CR`.`Title` AS `Title`,`CR`.`Subtitle` AS `Subtitle`,`CR`.`SiteNum` AS `SiteNum`,IFNULL(`CR`.`CollInfo`,`C`.`CollInfo`) AS `CollInfo` FROM `cargo__Cards` `C` LEFT OUTER JOIN `cargo__CardReleases` `CR` ON ((`C`.`ID`=`CR`.`ID`)) WHERE `CR`.`Types__full` = 'Possession' AND `C`.`Subset` NOT IN ('M', 'A', 'O', 'T', 'J') AND (`C`.`SetNum` <> '0' OR `C`.`Subset` IN ('W', 'L') OR `C`.`CardNum` IN (56, 57, 58, 59, 60, 62, 63, 64, 65, 66, 67)) AND `CR`.`Title` = "Warg" ORDER BY CASE WHEN CAST(`C`.`SetNum` AS UNSIGNED INTEGER) < 20 THEN 0 WHEN LEFT(`C`.`SetNum`, 1) = 'V' THEN 1 ELSE 2 END,CASE `C`.`Side` WHEN 'Free Peoples' THEN 1 WHEN 'Shadow' THEN 2 WHEN 'None' THEN CASE WHEN `C`.`Culture` = 'The One Ring' THEN 0 ELSE 3 END ELSE 4 END,CASE WHEN `C`.`Culture` = 'The One Ring' THEN 'AAA' WHEN `C`.`Culture` = 'Site' THEN 'ZZZ' ELSE `C`.`Culture` END,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` LIMIT 100
