- рус
- укр
Кофты для девочки
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,7679,9537,12821)
GROUP BY affi.pid
HAVING SUM(CASE WHEN affi.fid IN (7611,7679,12821) THEN 1 ELSE 0 END) > 0 AND SUM(CASE WHEN affi.fid IN (9537) 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=1
Сортировка по:
This site is protected by reCAPTCHA and the Google
Privacy Policy and
Terms of Service apply.
© 2021-2025 ШАРА ПЛЮС Все права защищены
Создано
