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 (7611,7615,7669,7685)
GROUP BY affi.pid
HAVING SUM(CASE WHEN affi.fid IN (7611,7615,7669,7685) THEN 1 ELSE 0 END) > 0) and translationId in (select distinct pid from products_categories where cid in (-1,647,649,655,661,955)) and active=1Array
(
[0] => 337268
[1] => 337830
[2] => 338326
[3] => 346298
[4] => 349782
[5] => 356292
[6] => 356312
)