SET STATEMENT max_statement_time=30 FOR SELECT COUNT(DISTINCT p.product_id) AS total FROM product p, product_description pd,currency cur,product_to_category p2c ,product_attribute atrstil1 ,product_attribute atrrazmer_polotna2 ,product_attribute atrosteklenie3 ,product_attribute atr_14 WHERE p2c.product_id = p.product_id AND p.product_id = pd.product_id AND pd.name!='' AND cur.code=p.currency and pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-10-24 09:44:00' AND p2c.category_id = '1' AND (atrstil1.language_id = '1' AND atrstil1.attribute_id in (select attribute_id from attribute_description where name_eng='stil' ) AND ( atrstil1.text_eng='klasika' OR atrstil1.text_eng like('%;klasika;%') OR atrstil1.text_eng like('%;klasika') OR atrstil1.text_eng like('klasika;%') OR atrstil1.text_eng='suchasniy' OR atrstil1.text_eng like('%;suchasniy;%') OR atrstil1.text_eng like('%;suchasniy') OR atrstil1.text_eng like('suchasniy;%') OR atrstil1.text_eng='hay-tek' OR atrstil1.text_eng like('%;hay-tek;%') OR atrstil1.text_eng like('%;hay-tek') OR atrstil1.text_eng like('hay-tek;%') OR atrstil1.text_eng='minimalizm' OR atrstil1.text_eng like('%;minimalizm;%') OR atrstil1.text_eng like('%;minimalizm') OR atrstil1.text_eng like('minimalizm;%') OR atrstil1.text_eng='modern' OR atrstil1.text_eng like('%;modern;%') OR atrstil1.text_eng like('%;modern') OR atrstil1.text_eng like('modern;%') )) AND (atrrazmer_polotna2.language_id = '1' AND atrrazmer_polotna2.attribute_id in (select attribute_id from attribute_description where name_eng='razmer-polotna' ) AND ( atrrazmer_polotna2.text_eng='standartniy' OR atrrazmer_polotna2.text_eng like('%;standartniy;%') OR atrrazmer_polotna2.text_eng like('%;standartniy') OR atrrazmer_polotna2.text_eng like('standartniy;%') OR atrrazmer_polotna2.text_eng='pid-zamovlennya' OR atrrazmer_polotna2.text_eng like('%;pid-zamovlennya;%') OR atrrazmer_polotna2.text_eng like('%;pid-zamovlennya') OR atrrazmer_polotna2.text_eng like('pid-zamovlennya;%') OR atrrazmer_polotna2.text_eng='pod-zakaz' OR atrrazmer_polotna2.text_eng like('%;pod-zakaz;%') OR atrrazmer_polotna2.text_eng like('%;pod-zakaz') OR atrrazmer_polotna2.text_eng like('pod-zakaz;%') )) AND (atrosteklenie3.language_id = '1' AND atrosteklenie3.attribute_id in (select attribute_id from attribute_description where name_eng='osteklenie' ) AND ( atrosteklenie3.text_eng='polotno-gluhe-bez-skla' OR atrosteklenie3.text_eng like('%;polotno-gluhe-bez-skla;%') OR atrosteklenie3.text_eng like('%;polotno-gluhe-bez-skla') OR atrosteklenie3.text_eng like('polotno-gluhe-bez-skla;%') OR atrosteklenie3.text_eng='pod-stekloso-steklom-tripleks' OR atrosteklenie3.text_eng like('%;pod-stekloso-steklom-tripleks;%') OR atrosteklenie3.text_eng like('%;pod-stekloso-steklom-tripleks') OR atrosteklenie3.text_eng like('pod-stekloso-steklom-tripleks;%') )) AND (atr_14.language_id = '1' AND atr_14.attribute_id in (select attribute_id from attribute_description where name_eng='-1' ) AND ( atr_14.text_eng='vidtinki-sirogo' OR atr_14.text_eng like('%;vidtinki-sirogo;%') OR atr_14.text_eng like('%;vidtinki-sirogo') OR atr_14.text_eng like('vidtinki-sirogo;%') OR atr_14.text_eng='ncs' OR atr_14.text_eng like('%;ncs;%') OR atr_14.text_eng like('%;ncs') OR atr_14.text_eng like('ncs;%') OR atr_14.text_eng='venge' OR atr_14.text_eng like('%;venge;%') OR atr_14.text_eng like('%;venge') OR atr_14.text_eng like('venge;%') OR atr_14.text_eng='svitliy' OR atr_14.text_eng like('%;svitliy;%') OR atr_14.text_eng like('%;svitliy') OR atr_14.text_eng like('svitliy;%') OR atr_14.text_eng='krem' OR atr_14.text_eng like('%;krem;%') OR atr_14.text_eng like('%;krem') OR atr_14.text_eng like('krem;%') OR atr_14.text_eng='chernyiy' OR atr_14.text_eng like('%;chernyiy;%') OR atr_14.text_eng like('%;chernyiy') OR atr_14.text_eng like('chernyiy;%') )) AND p.product_id = atrstil1.product_id AND p.product_id = atrrazmer_polotna2.product_id AND p.product_id = atrosteklenie3.product_id AND p.product_id = atr_14.product_id
 Межкомнатные двери, купить межкомнатные двери в Киеве с доставкой по Украние в онлайн каталоге "Просто Двери"
Категории
Фильтр товаров
Цена
Врезка фурнитуры
Покрытие
Размер полотна
Остекление
Стиль
Цвет
Страна производитель
Рекомендуем
PUNTO QL Blade
PUNTO QL Blade
527.56 грн.
Modena
Modena
3399 грн.
3165 грн.
Интернет магазин дверей » Межкомнатные двери --> -->

Межкомнатные двери

В этой категории нет товаров.
Продолжить