Drilldown: ItemsTable
Jump to navigation
Jump to search
BasePV:
MaxPV:
Vibro:
PoweredPV:
Damage:
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: (Click arrow to add another value)
JoinKey: (Click arrow to add another value)
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 > BasePV:
4 
& AV:
4-8
& Skill :
Heavy Weapon or
no skill
& ElementalType:
None
& JoinKey :
Flawless crysteel shardmail or
Jeweled sandals or
Kah's loop or
Kaleidocera cape
& AV:
4-8
& Skill :
Heavy Weapon or
no skill
& ElementalType:
None
& JoinKey :
Flawless crysteel shardmail or
Jeweled sandals or
Kah's loop or
Kaleidocera cape Use the filters below to narrow your results.
BasePV:
MaxPV:
Vibro:
PoweredPV:
Damage:
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: (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' OR `ItemsTable_alias`.`JoinKey` = 'Kaleidocera cape') ORDER BY `Item...' at line 1 (localhost)
Function: CargoSQLQuery::run
Query: SELECT `ItemsTable_alias`.`_pageName` AS `_pageName` FROM `ItemsTable` `ItemsTable_alias` WHERE (`ItemsTable_alias`.`BasePV` = '4') AND ((`ItemsTable_alias`.`AV` >= 4 AND `ItemsTable_alias`.`AV` <= 8) ) AND (`ItemsTable_alias`.`Skill` = 'Heavy Weapon' OR `ItemsTable_alias`.`Skill` = 'no skill') AND (((`ItemsTable_alias`.`ElementalType` = '' AND `ItemsTable_alias`.`ElementalType` != 0) OR `ItemsTable_alias`.`ElementalType` IS NULL) ) AND (`ItemsTable_alias`.`JoinKey` = 'Flawless crysteel shardmail' OR `ItemsTable_alias`.`JoinKey` = 'Jeweled sandals' OR `ItemsTable_alias`.`JoinKey` = 'Kah's loop' OR `ItemsTable_alias`.`JoinKey` = 'Kaleidocera cape') ORDER BY `ItemsTable_alias`.`_pageName` LIMIT 250