8,756
edits
Template:Creature navbox query: Difference between revisions
Template:Creature navbox query (view source)
Revision as of 19:02, 26 December 2021
, 19:02, 26 December 2021exclude pets
(optimizing) |
(exclude pets) |
||
| Line 3: | Line 3: | ||
|q?join=CF.ObjectID=GD.ObjectID, CF.ObjectID=EI.ObjectID | |q?join=CF.ObjectID=GD.ObjectID, CF.ObjectID=EI.ObjectID | ||
|q?fields={{favilink format args}} | |q?fields={{favilink format args}} | ||
|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}}}')}} AND GD.Categories <> 'Pets' | ||
|q?groupBy=GD.ObjectID | |q?groupBy=GD.ObjectID | ||
|template=favilink format | |template=favilink format | ||