Unable to run pageCountMySQL server has gone awaySELECT 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)
						    WHERE 1 AND p.`Deleted`=0  AND p.Visible=1 AND ( CategoryID1 IN (4)
						or
					    CategoryID2 IN (4)
						or
					    CategoryID IN (4)
						)
					 ) as t