Template:In faction: Difference between revisions
Jump to navigation
Jump to search
(update query to fix bug if two creatures have the same plainname) |
|||
Line 1: | Line 1: | ||
==Creatures in the {{{1|{{#titleparts:{{PAGENAME}}}}}}} Faction== | ==Creatures in the {{{1|{{#titleparts:{{PAGENAME}}}}}}} Faction== | ||
{{#cargo_query:tables=CreatureFactions=CF,GeneralData=GD,Characters=C | |||
|join on = CF.JoinKey=GD.JoinKey, C.JoinKey=CF.JoinKey | |||
| | |fields=CONCAT('{{((}}favilink page{{!}}' , GD._pageName, '{{))}}'), Level | ||
| | |where=Faction="{{{1|{{#titleparts:{{PAGENAME}}}}}}}" AND CF._pageNamespace='0' AND GD.DisplayChar <> '' | ||
| | |order by=Level, PlainName | ||
| | |group by = C._pageName | ||
| | |format = ul | ||
| | |columns = 2}} | ||
| | <noinclude>[[Category:Query Templates]]</noinclude> |
Revision as of 00:59, 27 January 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