Каталог

Фильтры

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

Цена (руб)

от

до

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

SHIVAKI

Unknown

Наличие

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

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

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

Под заказ

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=559 group by catalog_props.id order by min(catalog_props_value.pos) asc

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

Пульты: shivakiс доставкой по России

товаров: 4

Сортировать

Код: 38025

Пульт ДУ Shivaki TV 105-088Q

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="0c9bf4aa-4ee5-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_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

556c

В корзину

под заказ

Код: 227300

Пульт ДУ Shivaki TV 2200-ED00SHIV

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="8c0ae568-4ac5-11ed-80be-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_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

600c

В корзину

в наличии

Код: 60739

Пульт ДУ Shivaki TV LCD-831

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="e8353ab3-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_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

571c

В корзину

под заказ

Код: 60740

Пульт ДУ Shivaki TV RC-A3-01

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="e8353ab4-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_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

524c

В корзину

под заказ