;WITH CTE_ProductReviews AS (
	SELECT p2p.path_id, p2p.prod_id, o.ReviewCount
	FROM p2p
	INNER JOIN (products) p ON p.prod_id = p2p.prod_id AND p.[status] = 0
	LEFT JOIN (SELECT product_id, COUNT(*) AS ReviewCount 
		FROM Reviews
		WHERE [status] = 0 
		GROUP BY product_id) o ON o.product_id = p.product_id
	WHERE p2p.[status] = 0)


SELECT c.name,
	d1.ProductCount AS 'Total products',
	d1.ReviewCount AS 'Total Reviews',
	d2.ProductCount AS 'Prod. With 1 Review'

FROM c

INNER JOIN pv ON pv.cat_id = c.cat_id AND pv.step = 1

INNER JOIN (SELECT path_id, 
		COUNT(*) AS ProductCount, 
		SUM(ReviewCount) AS ReviewCount 
	FROM CTE_ProductReviews 
	GROUP BY path_id) d1 ON d1.path_id = pv.path_id

INNER JOIN (SELECT path_id, 
		COUNT(*) AS ProductCount 
	FROM CTE_ProductReviews
	WHERE ReviewCount = 1 
	GROUP BY path_id) d2 ON d2.path_id = pv.path_id

WHERE c.[status] = 0   
 
ORDER BY c.name

We walk in the dark places no others will enter
We stand on the bridge and no one may pass