Каталог

Фильтры

Сбросить фильтры

Цена (руб)

от

до

Производители

Ballu

NEOCLIMA

Thermex

Наличие

Только в наличии

В наличии Петрозаводск

В наличии Архангельск

Под заказ

Select catalog_props.* from catalog_props, catalog_props_value, catalog where catalog_props.id=catalog_props_value.idp and catalog.id=catalog_props_value.idc and catalog.category=631 group by catalog_props.id order by min(catalog_props_value.pos) asc

Disk full (/tmp/#sql_76e4_6.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

Климатическое оборудование: водонагревателис доставкой по России

товаров: 6

Сортировать

Код: 202089

Водонагреватель ballu BWH/S 100 литров SMART бойлер накопительный нержавейка

Select P.short, V.idv, P.title as pname, B.title as vname from catalog_values as V, catalog_properties as P, catalog_propbook as B where V.idc="6193aacc-95f7-11ea-80b8-0cc47a52ebf7" and V.idp=P.id and V.idv=B.id order by P.tomain desc, P.title asc limit 3

Disk full (/tmp/#sql_76e4_6.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

12205c

В корзину

под заказ

Код: 123036

Водонагреватель ballu BWH/S 100 литров Primex бойлер

Select P.short, V.idv, P.title as pname, B.title as vname from catalog_values as V, catalog_properties as P, catalog_propbook as B where V.idc="3ddc3a7f-d5f3-11e9-8cb1-0cc47a52ebf7" and V.idp=P.id and V.idv=B.id order by P.tomain desc, P.title asc limit 3

Disk full (/tmp/#sql_76e4_6.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

13489c

В корзину

под заказ

Код: 88559

Водонагреватель ballu BWH/S 30 литров RODON бойлер

Select P.short, V.idv, P.title as pname, B.title as vname from catalog_values as V, catalog_properties as P, catalog_propbook as B where V.idc="a0001f9c-4ee7-11e8-936d-0cc47a52ebf7" and V.idp=P.id and V.idv=B.id order by P.tomain desc, P.title asc limit 3

Disk full (/tmp/#sql_76e4_6.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

14681c

В корзину

под заказ

Код: 88560

Водонагреватель ballu BWH/S 50 литров RODON бойлер

Select P.short, V.idv, P.title as pname, B.title as vname from catalog_values as V, catalog_properties as P, catalog_propbook as B where V.idc="a0001f9e-4ee7-11e8-936d-0cc47a52ebf7" and V.idp=P.id and V.idv=B.id order by P.tomain desc, P.title asc limit 3

Disk full (/tmp/#sql_76e4_6.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

17458c

В корзину

под заказ

Код: 88562

Водонагреватель ballu BWH/S 100 литров Trust бойлер накопительный эмаль

Select P.short, V.idv, P.title as pname, B.title as vname from catalog_values as V, catalog_properties as P, catalog_propbook as B where V.idc="a0001fa6-4ee7-11e8-936d-0cc47a52ebf7" and V.idp=P.id and V.idv=B.id order by P.tomain desc, P.title asc limit 3

Disk full (/tmp/#sql_76e4_6.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

13093c

В корзину

под заказ

Код: 201868

Водонагреватель NeoClima EWHI 80SH NeoClima

Select P.short, V.idv, P.title as pname, B.title as vname from catalog_values as V, catalog_properties as P, catalog_propbook as B where V.idc="67856888-892b-11ea-80b8-0cc47a52ebf7" and V.idp=P.id and V.idv=B.id order by P.tomain desc, P.title asc limit 3

Disk full (/tmp/#sql_76e4_6.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

15712c

В корзину

под заказ