Cargo query

Showing below up to 8 results in range #101 to #108.

View (previous 100 | next 100) (20 | 50 | 100 | 250 | 500)

Table(s):
Field(s):
Where:	EI.Info LIKE '%EMP Sensitive,,,%' AND GD._pageNamespace = 0 AND CF.Value IS NULL AND IT.WornOn 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')
Join on:	GD.JoinKey=EI.JoinKey,GD.JoinKey=IT.JoinKey,GD.ObjectID=CF.ObjectID
Group by:
Having:
Order by:

Limit:
Offset:
Format:

View wikitext

{{#cargo_query:
tables=GeneralData=GD,ExtraInfo=EI,ItemsTable=IT,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 IT.WornOn 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')
|join on=GD.JoinKey=EI.JoinKey,GD.JoinKey=IT.JoinKey,GD.ObjectID=CF.ObjectID
|order by=`GD`.`Categories` , `GD`.`_pageName` 
|format=ul
|offset=100
|limit=100
}}