User:Cease/Temp3
From LOTR-TCG Wiki
Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'NOT `C`.`CardType` = 'character' ORDER BY `CR`.`SiteNum` LIMIT 100' at line 1
Function: CargoSQLQuery::run Query: SELECT `CR`.`_pageID` AS `cargo_backlink_page_id_CR`,`C`.`_pageID` AS `cargo_backlink_page_id_C`,CONCAT('<span class="tooltip">', `CR`.`Title`, CASE WHEN `CR`.`Subtitle` IS NULL THEN ELSE CONCAT(', ', `CR`.`Subtitle`) END, ' (', IFNULL(`CR`.`CollInfo`,`C`.`CollInfo`), ')<span>File:', IFNULL(`CR`.`ImageFilename`,'Card Not Found.jpg'), '</span></span>') AS `CardName` FROM `cargo__Cards` `C` LEFT OUTER JOIN `cargo__CardReleases` `CR` ON ((`C`.`ID`=`CR`.`ID`)) WHERE `CR`.`GameText` LIKE '%defender%' AND `C`.`Side` = 'Free Peoples' NOT `C`.`CardType` = 'character' ORDER BY `CR`.`SiteNum` LIMIT 100