Drilldown: ItemsTable
Jump to navigation
Jump to search
Choose a table:
- Anatomies (737)
- ArtifactData (441)
- Characters (1101)
- CookingEffects (65)
- CorpseTables (78)
- Corpses (118)
- CreatureFactions (704)
- CreatureMutations (860)
- Cybernetics (77)
- DynamicObjects (1939)
- Effects (82)
- EncounterTableRows (2118)
- EncounterTables (70)
- ExtraInfo (1718)
- FactionFeelings (138)
- Factions (76)
- Food (138)
- FurnitureData (25)
- GeneralData (2800)
- Inventory (1298)
- ItemsTable (1177)
- Liquids (27)
- Locations (42)
- MissileWeaponData (66)
- Modability (563)
- Mods (65)
- Mutations (130)
- OnEatEffects (21)
- PhysicalProperties (1080)
- Quests (27)
- Recipes (10)
- ReputationBonuses (49)
- Skills (154)
- VersHist (679)
- VersHistInfobox (2636)
- WaterRitualSkills (16)
- All pages (14277)
ItemsTable > EgoBonus:
None
& UsesSlots:
Head
& JoinKey :
3D cobblers or
Inflatable axons or
Iron buckler or
Iron dagger or
Iron long sword or
Kaleidocera cape or
Miner's helmet
Use the filters below to narrow your results.
Showing below up to 1 result in range #1 to #1.
View (previous 250 | next 250) (20 | 50 | 100 | 250 | 500)
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 helmet') ORDER BY `ItemsTable_alias`.`_pageName` LIMIT 250' at line 1 (localhost)
Function: CargoSQLQuery::run
Query: SELECT `ItemsTable_alias`.`_pageName` AS `_pageName` FROM `ItemsTable` `ItemsTable_alias` LEFT OUTER JOIN `ItemsTable__UsesSlots` `ItemsTable_alias__UsesSlots` ON ((`ItemsTable_alias`.`_ID`=`ItemsTable_alias__UsesSlots`.`_rowID`)) WHERE (((`ItemsTable_alias`.`EgoBonus` = '' AND `ItemsTable_alias`.`EgoBonus` != 0) OR `ItemsTable_alias`.`EgoBonus` IS NULL) ) AND (`ItemsTable_alias__UsesSlots`.`_value` = 'Head') AND (`ItemsTable_alias`.`JoinKey` = '3D cobblers' OR `ItemsTable_alias`.`JoinKey` = 'Inflatable axons' OR `ItemsTable_alias`.`JoinKey` = 'Iron buckler' OR `ItemsTable_alias`.`JoinKey` = 'Iron dagger' OR `ItemsTable_alias`.`JoinKey` = 'Iron long sword' OR `ItemsTable_alias`.`JoinKey` = 'Kaleidocera cape' OR `ItemsTable_alias`.`JoinKey` = 'Miner's helmet') ORDER BY `ItemsTable_alias`.`_pageName` LIMIT 250