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 (7617,7639,7673,9543)
GROUP BY affi.pid
HAVING SUM(CASE WHEN affi.fid IN (7617,7639,7673) 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=1Array
(
[0] => 244258
[1] => 245440
[2] => 326450
[3] => 326452
[4] => 87960
[5] => 87968
[6] => 88372
[7] => 88598
[8] => 88606
[9] => 243686
)