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 (14272)
ItemsTable > Vibro:
No
& UsesSlots :
Floating Nearby or
Hand
& HarvestedInto:
None
& PreservedQuantity:
None
& JoinKey :
Amaranthine prism or
Iron mace or
Kah's loop
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 loop') 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`.`Vibro` = '0') AND (`ItemsTable_alias__UsesSlots`.`_value` = 'Floating Nearby' OR `ItemsTable_alias__UsesSlots`.`_value` = 'Hand') AND (((`ItemsTable_alias`.`HarvestedInto` = '' AND `ItemsTable_alias`.`HarvestedInto` != 0) OR `ItemsTable_alias`.`HarvestedInto` IS NULL) ) AND (((`ItemsTable_alias`.`PreservedQuantity` = '' AND `ItemsTable_alias`.`PreservedQuantity` != 0) OR `ItemsTable_alias`.`PreservedQuantity` IS NULL) ) AND (`ItemsTable_alias`.`JoinKey` = 'Amaranthine prism' OR `ItemsTable_alias`.`JoinKey` = 'Iron mace' OR `ItemsTable_alias`.`JoinKey` = 'Kah's loop') ORDER BY `ItemsTable_alias`.`_pageName` LIMIT 250