Template:In faction: Difference between revisions
Jump to navigation
Jump to search
(changed columns back to 1) |
mNo edit summary |
||
Line 2: | Line 2: | ||
{{#cargo_query:tables=CreatureFactions=CF,GeneralData=GD,Characters=C | {{#cargo_query:tables=CreatureFactions=CF,GeneralData=GD,Characters=C | ||
|join on = CF.JoinKey=GD.JoinKey, C.JoinKey=CF.JoinKey | |join on = CF.JoinKey=GD.JoinKey, C.JoinKey=CF.JoinKey | ||
|fields=CONCAT( | |fields=CONCAT("{{((}}favilink page{{!}}" , GD._pageName, "{{))}}"), Level | ||
|where=Faction="{{{1|{{#titleparts:{{PAGENAME}}}}}}}" AND CF._pageNamespace='0' AND GD.DisplayChar <> '' | |where=Faction="{{{1|{{#titleparts:{{PAGENAME}}}}}}}" AND CF._pageNamespace='0' AND GD.DisplayChar <> '' | ||
|order by=Level, PlainName | |order by=Level, PlainName |
Revision as of 22:26, 19 July 2020
Creatures in the In faction Faction
Error 1054: Unknown column 'CF.JoinKey' in 'on clause' (localhost)
Function: CargoSQLQuery::run Query: SELECT CONCAT("{{favilink page|" , `GD`.`_pageName`, "}}") AS `_pageName, "}}")`,`Level` AS `Level` FROM `CreatureFactions` `CF` LEFT OUTER JOIN `GeneralData` `GD` ON ((`CF`.`JoinKey`=`GD`.`JoinKey`)) LEFT OUTER JOIN `Characters` `C` ON ((`CF`.`JoinKey`=`C`.`JoinKey`)) WHERE Faction="In faction" AND `CF`.`_pageNamespace`='0' AND `GD`.`DisplayChar` <> GROUP BY `C`.`_pageName` ORDER BY `Level`,`PlainName` LIMIT 100