Сантехника

Сантехника - это раковины, унитазы, биде и писсуары, а также водосливная арматура и комплектующие к ним. В этом разделе вы найдете сантехнику из искусственного камня, из стали, ну и, конечно, из керамики или фаянса. Сантехника фабрики Scarabeo - это наш профиль, мы продаем ее с 2019 года. Более 200 позиций санфаянса всегда есть в наличии на нашем складе в Москве. Цветная матовая сантехника - тренд последних лет - её можно посмотреть и онлайн, и в нашем офисе на ул. Декабристов, д.4 корп.2, помещение 1/1.

Оставьте заявку на сайте или позвоните по телефону 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` = 15 ) ) 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(107) ) AS `tmp` WHERE `product_id` IN( SELECT `product_id` FROM `oc_product_attribute` WHERE ( ) AND `language_id` = 1 AND `attribute_id` = 15 ) ) 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
  • Коллекция
  • Страна
  • Материал
  • Цвет
  • Стиль
  • Форма
  • Длина
  • Ширина
    -
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` = 15 )' 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(197) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND `cp`.`path_id` IN(197)) AS `tmp` WHERE `product_id` IN( SELECT `product_id` FROM `oc_product_attribute` WHERE ( ) AND `language_id` = 1 AND `attribute_id` = 15 ) 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` = 15 )' 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(131) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND `cp`.`path_id` IN(131)) AS `tmp` WHERE `product_id` IN( SELECT `product_id` FROM `oc_product_attribute` WHERE ( ) AND `language_id` = 1 AND `attribute_id` = 15 ) 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` = 15 )' 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(132) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND `cp`.`path_id` IN(132)) AS `tmp` WHERE `product_id` IN( SELECT `product_id` FROM `oc_product_attribute` WHERE ( ) AND `language_id` = 1 AND `attribute_id` = 15 ) 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` = 15 )' 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(133) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND `cp`.`path_id` IN(133)) AS `tmp` WHERE `product_id` IN( SELECT `product_id` FROM `oc_product_attribute` WHERE ( ) AND `language_id` = 1 AND `attribute_id` = 15 ) 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` = 15 )' 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(211) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND `cp`.`path_id` IN(211)) AS `tmp` WHERE `product_id` IN( SELECT `product_id` FROM `oc_product_attribute` WHERE ( ) AND `language_id` = 1 AND `attribute_id` = 15 ) 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` = 15 )' 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(208) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND `cp`.`path_id` IN(208)) AS `tmp` WHERE `product_id` IN( SELECT `product_id` FROM `oc_product_attribute` WHERE ( ) AND `language_id` = 1 AND `attribute_id` = 15 ) 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` = 15 )' 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(180) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND `cp`.`path_id` IN(180)) AS `tmp` WHERE `product_id` IN( SELECT `product_id` FROM `oc_product_attribute` WHERE ( ) AND `language_id` = 1 AND `attribute_id` = 15 ) 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` = 15 )' 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(179) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND `cp`.`path_id` IN(179)) AS `tmp` WHERE `product_id` IN( SELECT `product_id` FROM `oc_product_attribute` WHERE ( ) AND `language_id` = 1 AND `attribute_id` = 15 ) 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