8,290
edits
Properties: Difference between revisions
m
update wall-related cargo queries
m (wall traps -> vents) |
m (update wall-related cargo queries) |
||
| Line 47: | Line 47: | ||
| fields= | | fields= | ||
CONCAT('{{((}}favilink id{{!}}',CONCAT(GD.ObjectID),'{{))}}')=Object | CONCAT('{{((}}favilink id{{!}}',CONCAT(GD.ObjectID),'{{))}}')=Object | ||
| where=EI.Info LIKE '%EMP Sensitive,,,%' AND GD._pageNamespace = 0 AND (GD.Categories = 'Walls' OR GD.Categories = ' | | where=EI.Info LIKE '%EMP Sensitive,,,%' AND GD._pageNamespace = 0 AND (GD.Categories = 'Walls' OR GD.Categories = 'Fences' OR GD.Categories = 'Vents' OR GD.Categories = 'Glass Walls' OR GD.Categories = 'Tech Walls' OR GD.Categories = 'Gemstone Walls' OR GD.Categories = 'Sultan Walls' OR GD.Categories = 'Murals' OR GD.Categories = 'Holographic Walls' OR GD.Categories = 'Force Fields') | ||
| format=ul | | format=ul | ||
| order by=GD._pageName | | order by=GD._pageName | ||
| Line 94: | Line 94: | ||
| fields= | | fields= | ||
CONCAT('{{((}}favilink id{{!}}',CONCAT(GD.ObjectID),'{{))}}')=Object | 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 <> ' | | 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 <> 'Fences' AND GD.Categories <> 'Vents' AND GD.Categories <> 'Glass Walls' AND GD.Categories <> 'Tech Walls' AND GD.Categories <> 'Gemstone Walls' AND GD.Categories <> 'Sultan Walls' AND GD.Categories <> 'Murals' AND GD.Categories <> 'Holographic Walls' AND GD.Categories <> 'Force Fields) | ||
| format=ul | | format=ul | ||
| order by=GD._pageName | | order by=GD._pageName | ||