Drilldown: ItemsTable
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 > PoweredPV:
No 
& Healing:
0
& PreservedInto :
Drop of Nectar or
None
& ElementalType :
Heat or
None
& JoinKey :
Crystal flowers or
Issachar rifle or
Kah's loop
& Healing:
0
& PreservedInto :
Drop of Nectar or
None
& ElementalType :
Heat or
None
& JoinKey :
Crystal flowers or
Issachar rifle or
Kah's loop Use the filters below to narrow your results.
BasePV:
MaxPV:
Vibro:
PoweredPV: (Click arrow to add another value)
Damage:
UnpoweredDamage:
PrimaryDamageElement:
HP:
AV:
DV:
MA:
ToHit:
Skill:
ObjectID:
AgilityBonus:
StrengthBonus:
WillpowerBonus:
ToughnessBonus:
IntelligenceBonus:
EgoBonus:
WornOn:
UsesSlots:
Healing: (Click arrow to add another value)
HarvestedInto:
PreservedInto: (Click arrow to add another value)
PreservedQuantity:
ElementalDamage:
ElementalType: (Click arrow to add another value)
JoinKey: (Click arrow to add another value)
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` WHERE (`ItemsTable_alias`.`PoweredPV` = '0') AND (`ItemsTable_alias`.`Healing` = '0') AND (`ItemsTable_alias`.`PreservedInto` = 'Drop of Nectar' OR ((`ItemsTable_alias`.`PreservedInto` = '' AND `ItemsTable_alias`.`PreservedInto` != 0) OR `ItemsTable_alias`.`PreservedInto` IS NULL) ) AND (`ItemsTable_alias`.`ElementalType` = 'Heat' OR ((`ItemsTable_alias`.`ElementalType` = '' AND `ItemsTable_alias`.`ElementalType` != 0) OR `ItemsTable_alias`.`ElementalType` IS NULL) ) AND (`ItemsTable_alias`.`JoinKey` = 'Crystal flowers' OR `ItemsTable_alias`.`JoinKey` = 'Issachar rifle' OR `ItemsTable_alias`.`JoinKey` = 'Kah's loop') ORDER BY `ItemsTable_alias`.`_pageName` LIMIT 250