Drilldown: Items
Choose a table:
- Achievements (69)
- Afflictions (157)
- Ammunition (58)
- Autofill tags (454)
- Characters (13)
- Console Commands (243)
- Creatures (54)
- Gatherable Materials (38)
- Installations (57)
- Items (497)
- Medical Items (0)
- Missions (109)
- PageStatus (1269)
- PageStatusSandbox (116)
- Submarines (30)
- Talents (168)
Items > name :
Ahab's Spear or
Iron Ore
& tags:
ore
& medicaltype:
None
& weapondamagemodifier:
None
& outpostminavailable:
None
& medicalmultiplier:
1
Use the filters below to narrow your results.
Showing below up to 1 result in range #1 to #1.
Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 's Spear' OR `Items_alias`.`name` = 'Iron Ore') AND (`Items_alias__tags`.`_val...' at line 1
Function: CargoSQLQuery::run
Query: SELECT `Items_alias`.`_pageName` AS `_pageName` FROM `cargo__Items` `Items_alias` LEFT OUTER JOIN `cargo__Items__tags` `Items_alias__tags` ON ((`Items_alias`.`_ID`=`Items_alias__tags`.`_rowID`)) WHERE (`Items_alias`.`name` = 'Ahab's Spear' OR `Items_alias`.`name` = 'Iron Ore') AND (`Items_alias__tags`.`_value` = 'ore') AND (((`Items_alias`.`medicaltype` = '' AND `Items_alias`.`medicaltype` != 0) OR `Items_alias`.`medicaltype` IS NULL) ) AND (((`Items_alias`.`weapondamagemodifier` = '' AND `Items_alias`.`weapondamagemodifier` != 0) OR `Items_alias`.`weapondamagemodifier` IS NULL) ) AND (((`Items_alias`.`outpostminavailable` = '' AND `Items_alias`.`outpostminavailable` != 0) OR `Items_alias`.`outpostminavailable` IS NULL) ) AND (`Items_alias`.`medicalmultiplier` = '1') ORDER BY `Items_alias`.`_pageName` LIMIT 250