Template:In faction by pagename: Difference between revisions
Jump to navigation
Jump to search
(Created page with "==Creatures in the {{{1|{{#titleparts:{{PAGENAME}}}}}}} Faction== {{#cargo_query:tables=CreatureFactions=CF,GeneralData=GD,Characters=C |join on = CF.JoinKey=GD.JoinKey, C.Joi...") |
mNo edit summary |
||
| Line 8: | Line 8: | ||
|format = ul | |format = ul | ||
|columns = 1}} | |columns = 1}} | ||
<noinclude>A version of [[Template:In faction]] that uses <code>favilink</code> instead of <code>favilink id</code>. | <noinclude> | ||
A version of [[Template:In faction]] that uses <code>favilink</code> instead of <code>favilink id</code>. | |||
Useful for factions with pages that share ObjectIDs (such as the TinkerTurret turrets in the Robot faction). | Useful for factions with pages that share ObjectIDs (such as the TinkerTurret turrets in the Robot faction). | ||
[[Category:Query Templates]]</noinclude> | [[Category:Query Templates]]</noinclude> | ||
Revision as of 18:09, 11 November 2020
Creatures in the In faction by pagename Faction
Error 1054: Unknown column 'CF.JoinKey' in 'on clause' (localhost)
Function: CargoSQLQuery::run Query: SELECT CONCAT("{{favilink|" , `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 by pagename" AND `CF`.`_pageNamespace`='0' AND `GD`.`DisplayChar` <> GROUP BY `C`.`_pageName` ORDER BY `Level`,`PlainName` LIMIT 100
A version of Template:In faction that uses favilink instead of favilink id.
Useful for factions with pages that share ObjectIDs (such as the TinkerTurret turrets in the Robot faction).