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.Category = '270'
AND CatItems.Active = '1'
group by CatItems.__id
Got error 28 from storage engine