- рус
- укр
Кофты
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 (7613,7637,7699,9555)
GROUP BY affi.pid
HAVING SUM(CASE WHEN affi.fid IN (7613,7637,7699) THEN 1 ELSE 0 END) > 0 AND SUM(CASE WHEN affi.fid IN (9555) 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] => 245440
[1] => 30534
[2] => 87830
[3] => 87954
[4] => 87958
[5] => 186620
[6] => 241486
[7] => 241770
[8] => 242000
[9] => 242332
[10] => 243686
[11] => 325306
[12] => 344436
[13] => 347282
[14] => 349776
[15] => 353010
[16] => 355478
)
Сортировка по:
This site is protected by reCAPTCHA and the Google
Privacy Policy and
Terms of Service apply.
© 2021-2025 ШАРА ПЛЮС Все права защищены
Создано
