Кофты

SELECT translationId FROM products where lang=:lang and (labelAction=1) AND translationId IN (SELECT affi.pid FROM all_filters_filters_items affi WHERE affi.fid IN (3243,7691,8093,9543) GROUP BY affi.pid HAVING SUM(CASE WHEN affi.fid IN (3243) THEN 1 ELSE 0 END) > 0 AND SUM(CASE WHEN affi.fid IN (7691,8093) THEN 1 ELSE 0 END) > 0 AND SUM(CASE WHEN affi.fid IN (9543) THEN 1 ELSE 0 END) > 0) and translationId in (select distinct pid from products_categories where cid in (-1,781,785,791,957,959)) and active=1