Unable to run pageCountLost connection to MySQL server during querySELECT 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 (423,474,427,473) OR CategoryID2 IN (423,474,427,473) ) as t