Unable to list itemsSELECT DISTINCT p.*,c.CatName FROM products p
LEFT JOIN categories c ON (p.CategoryID1=c.id)
LEFT JOIN products_categories pc ON (p.id=pc.ProductID)
LEFT JOIN subproducts sp ON (p.id=sp.ProductID AND sp.Visible=1 AND sp.Deleted=0)
WHERE 1 AND p.`Deleted`=0 AND CategoryID1 IN (423,474,427,473) OR CategoryID2 IN (423,474,427,473) ORDER BY p.priority asc, p.ItemName asc LIMIT 1000 Got error 12 "Cannot allocate memory" from storage engine Aria