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 '%dualspear%' and b.Stat like '%matk%' and a.EnchantLevel ='6' Got error 28 from storage engine