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 (14273)
ItemsTable > MaxPV:
8-1100 
& Damage :
1d2 or
1d6
& Skill:
no skill
& WillpowerBonus:
None
& JoinKey :
Ironweave cloak or
Kah's loop or
Large stone
& Damage :
1d2 or
1d6
& Skill:
no skill
& WillpowerBonus:
None
& JoinKey :
Ironweave cloak or
Kah's loop or
Large stone Use the filters below to narrow your results.
BasePV:
MaxPV:
Vibro:
PoweredPV:
Damage: (Click arrow to add another value)
UnpoweredDamage:
PrimaryDamageElement:
HP:
AV:
DV:
MA:
ToHit:
Skill: (Click arrow to add another value)
ObjectID:
AgilityBonus:
StrengthBonus:
WillpowerBonus:
ToughnessBonus:
IntelligenceBonus:
EgoBonus:
WornOn:
UsesSlots:
Healing:
HarvestedInto:
PreservedInto:
PreservedQuantity:
ElementalDamage:
ElementalType:
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' OR `ItemsTable_alias`.`JoinKey` = 'Large stone') ORDER BY `ItemsTabl...' at line 1 (localhost)
Function: CargoSQLQuery::run
Query: SELECT `ItemsTable_alias`.`_pageName` AS `_pageName` FROM `ItemsTable` `ItemsTable_alias` WHERE ((`ItemsTable_alias`.`MaxPV` >= 8 AND `ItemsTable_alias`.`MaxPV` <= 1100) ) AND (`ItemsTable_alias`.`Damage` = '1d2' OR `ItemsTable_alias`.`Damage` = '1d6') AND (`ItemsTable_alias`.`Skill` = 'no skill') AND (((`ItemsTable_alias`.`WillpowerBonus` = '' AND `ItemsTable_alias`.`WillpowerBonus` != 0) OR `ItemsTable_alias`.`WillpowerBonus` IS NULL) ) AND (`ItemsTable_alias`.`JoinKey` = 'Ironweave cloak' OR `ItemsTable_alias`.`JoinKey` = 'Kah's loop' OR `ItemsTable_alias`.`JoinKey` = 'Large stone') ORDER BY `ItemsTable_alias`.`_pageName` LIMIT 250