Unable to run pageCountGot error 12 "Cannot allocate memory" from storage engine AriaSELECT COUNT(*) AS recCount FROM (SELECT 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 (460,461,462,464,465,466,467,470,468,463,469) OR CategoryID2 IN (460,461,462,464,465,466,467,470,468,463,469) ) as t