Drilldown: ItemsTable

Jump to navigation Jump to search
ItemsTable > MaxPV: 5-1000 & Damage: 2d8 & ElementalDamage : 1d10+19 or 1d6+9 or 3-4 or None & JoinKey : Kah's loop or Zetachrome long sword

Use the filters below to narrow your results.

BasePV:
MaxPV:
Vibro:
PoweredPV:
Damage: (Click arrow to add another value)
UnpoweredDamage:
PrimaryDamageElement:
ToHit:
ObjectID:
AgilityBonus:
StrengthBonus:
WillpowerBonus:
ToughnessBonus:
IntelligenceBonus:
EgoBonus:
WornOn:
UsesSlots:
Healing:
HarvestedInto:
PreservedInto:
PreservedQuantity:
ElementalDamage: (Click arrow to add another value)
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` = 'Zetachrome long sword') ORDER BY ...' at line 1 (localhost) Function: CargoSQLQuery::run Query: SELECT `ItemsTable_alias`.`_pageName` AS `_pageName` FROM `ItemsTable` `ItemsTable_alias` WHERE ((`ItemsTable_alias`.`MaxPV` >= 5 AND `ItemsTable_alias`.`MaxPV` <= 1000) ) AND (`ItemsTable_alias`.`Damage` = '2d8') AND (`ItemsTable_alias`.`ElementalDamage` = '1d10+19' OR `ItemsTable_alias`.`ElementalDamage` = '1d6+9' OR (`ItemsTable_alias`.`ElementalDamage` >= 3 AND `ItemsTable_alias`.`ElementalDamage` <= 4) OR ((`ItemsTable_alias`.`ElementalDamage` = '' AND `ItemsTable_alias`.`ElementalDamage` != 0) OR `ItemsTable_alias`.`ElementalDamage` IS NULL) ) AND (`ItemsTable_alias`.`JoinKey` = 'Kah's loop' OR `ItemsTable_alias`.`JoinKey` = 'Zetachrome long sword') ORDER BY `ItemsTable_alias`.`_pageName` LIMIT 250

View (previous 250 | next 250) (20 | 50 | 100 | 250 | 500)