Template:In faction: Difference between revisions
Jump to navigation
Jump to search
(update query to fix bug if two creatures have the same plainname) |
(changed columns back to 1) |
||
Line 7: | Line 7: | ||
|group by = C._pageName | |group by = C._pageName | ||
|format = ul | |format = ul | ||
|columns = | |columns = 1}} | ||
<noinclude>[[Category:Query Templates]]</noinclude> | <noinclude>[[Category:Query Templates]]</noinclude> |
Revision as of 00:41, 31 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