Cargo query

Jump to navigation Jump to search
Modify query

View wikitext
{{#cargo_query:
tables=GeneralData=GD,ExtraInfo=EI,CreatureFactions=CF
|fields=CONCAT('{{favilink id|',CONCAT(GD.ObjectID),'}}')=Object
|where=EI.Info LIKE '%EMP Sensitive,,,%' AND GD._pageNamespace = 0 AND CF.Value IS NULL AND (GD.Categories <> 'Melee Weapons' AND GD.Categories <> 'Axes' AND GD.Categories <> 'Long Blades' AND GD.Categories <> 'Short Blades' AND GD.Categories <> 'Cudgels' AND GD.Categories <> 'Rifles' AND GD.Categories <> 'Pistols' AND GD.Categories <> 'Bows' AND GD.Categories <> 'Heavy Weapons' AND GD.Categories <> 'Thrown Weapons' AND GD.ObjectID <> 'Point-Defense Drone' AND GD.Categories <> 'Furniture' AND GD.Categories <> 'Chairs' AND GD.Categories <> 'Walls' AND GD.Categories <> 'Wall Traps')
|join on=GD.JoinKey=EI.JoinKey,GD.ObjectID=CF.ObjectID
|order by=GD._pageName 
|format=ul
|offset=100
|limit=100
}}