Fixing PVP power on dungeon items with Resilience

Select *
FROM  item_template

WHERE InventoryType IN (2, 11, 12, 16)
AND stat_type9 = 35 and if(name LIKE "Bloodforged%", stat_value9 BETWEEN 0 AND 100 , stat_value9 BETWEEN 1 AND 100) AND pvppower BETWEEN 1 and 100 AND spellid_4 <> 0
AND requiredlevel BETWEEN 41 AND 70;



Select *
FROM  item_template

WHERE InventoryType IN (13, 14, 15, 21, 21, 22, 23, 25, 26, 28)
AND stat_type9 = 35 and if(name LIKE "Bloodforged%", stat_value9 BETWEEN 0 AND 100 , stat_value9 BETWEEN 1 AND 100) AND pvppower BETWEEN 1 and 100 AND spellid_4 <> 0
AND requiredlevel BETWEEN 41 AND 70;



Select *
FROM  item_template

WHERE InventoryType IN (17)
AND stat_type9 = 35 and if(name LIKE "Bloodforged%", stat_value9 BETWEEN 0 AND 100 , stat_value9 BETWEEN 1 AND 100) AND pvppower BETWEEN 1 and 100 AND spellid_4 <> 0
AND requiredlevel BETWEEN 41 AND 70;