Template:In faction: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
mNo edit summary |
||
Line 8: | Line 8: | ||
|format = ul | |format = ul | ||
|columns = 1}} | |columns = 1}} | ||
<noinclude>[[Category:Query Templates]]</noinclude> | <noinclude> | ||
See also [[Template:In faction by pagename]]. | |||
[[Category:Query Templates]]</noinclude> |
Revision as of 18:10, 11 November 2020
Creatures in the In faction Faction
Error 1054: Unknown column 'CF.JoinKey' in 'on clause' (localhost)
Function: CargoSQLQuery::run Query: SELECT CONCAT("{{favilink id|" , `GD`.`ObjectID`, "}}") AS `ObjectID, "}}")`,`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
See also Template:In faction by pagename.