Invalid query: SELECT CatItems.*, ROUND(AVG(cir.rating), 1) as avg_rating FROM CatItems left join CatItemReviews cir on cir.Item_id = CatItems.__id AND cir.Active = '1' AND cir.Rating <> '0' where CatItems.Active = '1' AND Category in (458) group by CatItems.__id ORDER BY CatItems.Quantity_stock desc limit 0, 12
Got error 28 from storage engine