SharuPoNemnogu

UPDATE ps_category pc
SET pc.active = 0
WHERE pc.level = 3 
	AND NOT EXISTS (
		SELECT 1 
		FROM ps_product pp
		INNER JOIN ps_category_product pcp ON pcp.id_product = pp.id_product
		WHERE pcp.id_category = pc.id_category
			AND pp.active = 1
		LIMIT 1
	);