8,756
edits
Template:Creature navbox query: Difference between revisions
Template:Creature navbox query (view source)
Revision as of 23:48, 6 February 2021
, 23:48, 6 February 2021join on objectid
(join on objectid) |
|||
| Line 1: | Line 1: | ||
<includeonly><span style="display:inline-block">{{#invoke:CargoQuery| main | <includeonly><span style="display:inline-block">{{#invoke:CargoQuery| main | ||
|q?tables=CreatureFactions=CF,GeneralData=GD,ExtraInfo=EI | |q?tables=CreatureFactions=CF,GeneralData=GD,ExtraInfo=EI | ||
|q?join=CF. | |q?join=CF.ObjectID=GD.ObjectID, CF.ObjectID=EI.ObjectID | ||
|q?fields=GD.ObjectID=Page | |q?fields=GD.ObjectID=Page | ||
|q?where=Faction='{{#replace:{{{1|}}}|'|\'}}' AND GD._pageNamespace ='0' {{#switch:{{{2|_NULL_}}}|common= AND (EI.Info NOT LIKE "%Unique,%" OR EI.Info IS NULL)|unique= AND EI.Info LIKE "%Unique,%"|}}{{#if:{{{category|}}}|AND GD.Categories = '{{{category}}}'}}{{#if:{{{notcategory|}}}|AND (GD.Categories IS NULL OR GD.Categories <> '{{{notcategory}}}')}} | |q?where=Faction='{{#replace:{{{1|}}}|'|\'}}' AND GD._pageNamespace ='0' {{#switch:{{{2|_NULL_}}}|common= AND (EI.Info NOT LIKE "%Unique,%" OR EI.Info IS NULL)|unique= AND EI.Info LIKE "%Unique,%"|}}{{#if:{{{category|}}}|AND GD.Categories = '{{{category}}}'}}{{#if:{{{notcategory|}}}|AND (GD.Categories IS NULL OR GD.Categories <> '{{{notcategory}}}')}} | ||