Choose a table:
- areas (71)
- condition sources (2133)
- conditions (1292)
- equipment (854)
- item icon (4111)
- misc items (2881)
- passives (990)
- spells (1642)
- voice actors (268)
- weapon types (33)
- weapons (417)
equipment > name :
'Magic' Ring or
Hoarfrost Boots
& type :
Boots or
Clothing or
Shields or
Underwear
& passives:
Hoarfrost Balance
Use the filters below to narrow your results.
Showing below up to 1 result in range #1 to #1.
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 'Magic' Ring' OR `equipment_alias`.`name` = 'Hoarfrost Boots') AND (`equipment...' at line 1
Function: CargoSQLQuery::run
Query: SELECT `equipment_alias`.`_pageName` AS `_pageName` FROM `cargo__equipment` `equipment_alias` LEFT OUTER JOIN `cargo__equipment__passives` `equipment_alias__passives` ON ((`equipment_alias`.`_ID`=`equipment_alias__passives`.`_rowID`)) WHERE (`equipment_alias`.`name` = ''Magic' Ring' OR `equipment_alias`.`name` = 'Hoarfrost Boots') AND (`equipment_alias`.`type` = 'Boots' OR `equipment_alias`.`type` = 'Clothing' OR `equipment_alias`.`type` = 'Shields' OR `equipment_alias`.`type` = 'Underwear') AND (`equipment_alias__passives`.`_value` = 'Hoarfrost Balance') ORDER BY `equipment_alias`.`_pageName` LIMIT 250