User:Cease/Temp3: Difference between revisions
From LOTR-TCG Wiki
No edit summary |
No edit summary |
||
| Line 3: | Line 3: | ||
|fields= | |fields= | ||
,CONCAT('<span class="tooltip">[[', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''), '|', 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>')=CardName | ,CONCAT('<span class="tooltip">[[', REPLACE(REPLACE(C._pageName, '/Data', ''), 'Data:', ''), '|', 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>')=CardName | ||
|where=CR.GameText LIKE '%defender%' AND C.Side = 'Free Peoples' | |where=CR.GameText LIKE '%defender%' AND C.Side = 'Free Peoples' NOT C.CardType = 'companion' | ||
|order by=CR.SiteNum | |order by=CR.SiteNum | ||
|limit=400 | |limit=400 | ||
Revision as of 03:19, 21 February 2022
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` = 'companion' 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` = 'companion' ORDER BY `CR`.`SiteNum` LIMIT 100
,_%27){kind=link}