Системы инсталляций

Системы инсталляции для унитазов, биде и писсуаров - новая данность современных ванных комнат. Наш интернет-магазин Whiesealshop.ru специализируется на продаже фабрики OLI, но как альтернативу вышеназванной фабрики, мы представили некоторые позиции Viega и Schell. 

OLI - это более 30ти видов инсталляций, более 100 моделей кнопок и более 1500 наименований сопутствующей продукции. Фабрика постоянно наращивает обороты и сегодня OLI - одна из первых европейских фабрик, которые имеют свое производство в России. 

Инсталляции немецких фабрики Viega и Schell не нуждаются в рекламе. Качество, проверенное временем и подтвержденное немецкими и мировыми сертификатами, всегда в цене. Оставьте заявку на сайте или позвоните по телефону 8 (916) 109 79 76 по будням – наши менеджеры готовы проконсультировать вас и помочь с выбором системы инсталляции для унитаза.

Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `language_id` = 1 AND `attribute_id` = 16 ) ) AS `tmp`' at line 58
Error No: 1064
SELECT MIN(`price`) AS `p_min`, MAX(`price`) AS `p_max` FROM( SELECT `price_tmp` AS `price` FROM( SELECT IFNULL( ( SELECT `price` FROM `oc_product_special` AS `ps` WHERE `ps`.`product_id` = `p`.`product_id` AND `ps`.`customer_group_id` = '1' AND ((`ps`.`date_start` = '0000-00-00' OR `ps`.`date_start` < NOW()) AND (`ps`.`date_end` = '0000-00-00' OR `ps`.`date_end` > NOW())) ORDER BY `ps`.`priority` ASC, `ps`.`price` ASC LIMIT 1 ), IFNULL( ( SELECT `price` FROM `oc_product_discount` AS `pd2` WHERE `pd2`.`product_id` = `p`.`product_id` AND `pd2`.`customer_group_id` = '1' AND `pd2`.`quantity` >= '1' AND ((`pd2`.`date_start` = '0000-00-00' OR `pd2`.`date_start` < NOW()) AND (`pd2`.`date_end` = '0000-00-00' OR `pd2`.`date_end` > NOW())) ORDER BY `pd2`.`priority` ASC, `pd2`.`price` ASC LIMIT 1 ), `p`.`price` ) ) AS `price_tmp` ,`p`.`product_id` FROM `oc_product` AS `p` INNER JOIN `oc_product_description` AS `pd` ON `pd`.`product_id` = `p`.`product_id` AND `pd`.`language_id` = 1 INNER JOIN `oc_product_to_store` AS `p2s` ON `p2s`.`product_id` = `p`.`product_id` AND `p2s`.`store_id` = 0 INNER JOIN `oc_product_to_category` AS `p2c` ON `p2c`.`product_id` = `p`.`product_id` INNER JOIN `oc_category_path` AS `cp` ON `cp`.`category_id` = `p2c`.`category_id` WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `cp`.`path_id` IN(103) ) AS `tmp` WHERE `product_id` IN( SELECT `product_id` FROM `oc_product_attribute` WHERE ( ) AND `language_id` = 1 AND `attribute_id` = 16 ) ) AS `tmp` in /home/h706062319/whitesealshop.ru/docs/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/h706062319/whitesealshop.ru/docs/system/library/mfilter_core.php on line 1

Фильтр

  • Фабрика
    0
    0
    0
  • Статус
    0
    0
    0
    0
  • Коллекция
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
  • Страна
  • Материал
  • Цвет
  • Длина
  • Ширина
  • Высота
Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `language_id` = 1 AND `attribute_id` = 16 )' at line 7
Error No: 1064
SELECT COUNT(DISTINCT `product_id`) AS `total` FROM(SELECT DISTINCT `p`.`product_id` FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `cp`.`path_id` IN(159) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND `cp`.`path_id` IN(159)) AS `tmp` WHERE `product_id` IN( SELECT `product_id` FROM `oc_product_attribute` WHERE ( ) AND `language_id` = 1 AND `attribute_id` = 16 ) in /home/h706062319/whitesealshop.ru/docs/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/h706062319/whitesealshop.ru/docs/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php on line 724Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `language_id` = 1 AND `attribute_id` = 16 )' at line 7
Error No: 1064
SELECT COUNT(DISTINCT `product_id`) AS `total` FROM(SELECT DISTINCT `p`.`product_id` FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `cp`.`path_id` IN(160) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND `cp`.`path_id` IN(160)) AS `tmp` WHERE `product_id` IN( SELECT `product_id` FROM `oc_product_attribute` WHERE ( ) AND `language_id` = 1 AND `attribute_id` = 16 ) in /home/h706062319/whitesealshop.ru/docs/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/h706062319/whitesealshop.ru/docs/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php on line 724Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `language_id` = 1 AND `attribute_id` = 16 )' at line 7
Error No: 1064
SELECT COUNT(DISTINCT `product_id`) AS `total` FROM(SELECT DISTINCT `p`.`product_id` FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `cp`.`path_id` IN(162) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND `cp`.`path_id` IN(162)) AS `tmp` WHERE `product_id` IN( SELECT `product_id` FROM `oc_product_attribute` WHERE ( ) AND `language_id` = 1 AND `attribute_id` = 16 ) in /home/h706062319/whitesealshop.ru/docs/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/h706062319/whitesealshop.ru/docs/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php on line 724Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `language_id` = 1 AND `attribute_id` = 16 )' at line 7
Error No: 1064
SELECT COUNT(DISTINCT `product_id`) AS `total` FROM(SELECT DISTINCT `p`.`product_id` FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `cp`.`path_id` IN(223) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND `cp`.`path_id` IN(223)) AS `tmp` WHERE `product_id` IN( SELECT `product_id` FROM `oc_product_attribute` WHERE ( ) AND `language_id` = 1 AND `attribute_id` = 16 ) in /home/h706062319/whitesealshop.ru/docs/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/h706062319/whitesealshop.ru/docs/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php on line 724Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `language_id` = 1 AND `attribute_id` = 16 )' at line 7
Error No: 1064
SELECT COUNT(DISTINCT `product_id`) AS `total` FROM(SELECT DISTINCT `p`.`product_id` FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `cp`.`path_id` IN(161) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND `cp`.`path_id` IN(161)) AS `tmp` WHERE `product_id` IN( SELECT `product_id` FROM `oc_product_attribute` WHERE ( ) AND `language_id` = 1 AND `attribute_id` = 16 ) in /home/h706062319/whitesealshop.ru/docs/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/h706062319/whitesealshop.ru/docs/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php on line 724Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `language_id` = 1 AND `attribute_id` = 16 )' at line 7
Error No: 1064
SELECT COUNT(DISTINCT `product_id`) AS `total` FROM(SELECT DISTINCT `p`.`product_id` FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `cp`.`path_id` IN(156) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND `cp`.`path_id` IN(156)) AS `tmp` WHERE `product_id` IN( SELECT `product_id` FROM `oc_product_attribute` WHERE ( ) AND `language_id` = 1 AND `attribute_id` = 16 ) in /home/h706062319/whitesealshop.ru/docs/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/h706062319/whitesealshop.ru/docs/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php on line 724Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `language_id` = 1 AND `attribute_id` = 16 )' at line 7
Error No: 1064
SELECT COUNT(DISTINCT `product_id`) AS `total` FROM(SELECT DISTINCT `p`.`product_id` FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `cp`.`path_id` IN(164) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND `cp`.`path_id` IN(164)) AS `tmp` WHERE `product_id` IN( SELECT `product_id` FROM `oc_product_attribute` WHERE ( ) AND `language_id` = 1 AND `attribute_id` = 16 ) in /home/h706062319/whitesealshop.ru/docs/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/h706062319/whitesealshop.ru/docs/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php on line 724Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `language_id` = 1 AND `attribute_id` = 16 )' at line 7
Error No: 1064
SELECT COUNT(DISTINCT `product_id`) AS `total` FROM(SELECT DISTINCT `p`.`product_id` FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `cp`.`path_id` IN(202) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND `cp`.`path_id` IN(202)) AS `tmp` WHERE `product_id` IN( SELECT `product_id` FROM `oc_product_attribute` WHERE ( ) AND `language_id` = 1 AND `attribute_id` = 16 ) in /home/h706062319/whitesealshop.ru/docs/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/h706062319/whitesealshop.ru/docs/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php on line 724