Template:In faction
Jump to navigation
Jump to search
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