Choose a table:
- areas (71)
- condition sources (2170)
- conditions (1294)
- equipment (855)
- item icon (4126)
- misc items (2882)
- passives (992)
- spells (1657)
- voice actors (268)
- weapon types (33)
- weapons (417)
equipment > name :
'Magic' Ring or
+1 Breastplate or
Absolute Outfit or
Underwear/Helper or
None
& type :
Shields or
Underwear
& passives :
Magical Plate (-2) or
None
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` = '+1 Breastplate' OR `equipment_ali...' 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` = '+1 Breastplate' OR `equipment_alias`.`name` = 'Absolute Outfit' OR `equipment_alias`.`name` = 'Underwear/Helper' OR ((`equipment_alias`.`name` = '' AND `equipment_alias`.`name` != 0) OR `equipment_alias`.`name` IS NULL) ) AND (`equipment_alias`.`type` = 'Shields' OR `equipment_alias`.`type` = 'Underwear') AND (`equipment_alias__passives`.`_value` = 'Magical Plate (-2)' OR ((`equipment_alias__passives`.`_value` = '' AND `equipment_alias__passives`.`_value` != 0) OR `equipment_alias__passives`.`_value` IS NULL) ) ORDER BY `equipment_alias`.`_pageName` LIMIT 250