Query Error: select count(a.ID) as total from enchantinfo as a LEFT JOIN (select * from enchantstatinfo group by EnchantClass) as b on a.EnchantClass = b.EnchantClass where 1=1 and a.ItemConstraint like '%weapon%' and a.EnchantLevel ='7' Got error 28 from storage engine