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 ') )' 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) LEFT JOIN oc_product_master pm ON pm.product_id = p.product_id WHERE `p`.`date_available` <= NOW() AND `p`.`status` = '1' AND `cp`.`path_id` IN(103) AND (pm.master_product_id = -1 OR pm.master_product_id = 0 OR pm.master_product_id = 0 OR pm.master_product_id IS NULL) AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND `cp`.`path_id` IN(103)) AS `tmp` WHERE `product_id` IN( SELECT `product_id` FROM `oc_product_option_value` WHERE `option_value_id` IN() ) in /home/m/m70189/doorexmoscow.ru/public_html/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/m/m70189/doorexmoscow.ru/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php on line 579Notice: 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 ') ) LIMIT 0,12' at line 7
Error No: 1064
SELECT * FROM(SELECT p.product_id, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM oc_product_discount 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) AS discount, (SELECT price FROM oc_product_special 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) AS special 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) LEFT JOIN oc_product_master pm ON pm.product_id = p.product_id WHERE `p`.`date_available` <= NOW() AND `p`.`status` = '1' AND `cp`.`path_id` IN(103) AND (pm.master_product_id = -1 OR pm.master_product_id = 0 OR pm.master_product_id = 0 OR pm.master_product_id IS NULL) AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND `cp`.`path_id` IN(103) GROUP BY p.product_id ORDER BY p.sort_order ASC, LCASE(pd.name) ASC ) AS `tmp` WHERE `product_id` IN( SELECT `product_id` FROM `oc_product_option_value` WHERE `option_value_id` IN() ) LIMIT 0,12 in /home/m/m70189/doorexmoscow.ru/public_html/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/m/m70189/doorexmoscow.ru/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php on line 230Warning: Invalid argument supplied for foreach() in /home/m/m70189/doorexmoscow.ru/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php on line 230Notice: 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 ') ) ) AS `tmp`' at line 53
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` = 3 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` WHERE `p`.`date_available` <= NOW() AND `p`.`status` = '1' AND `p2c`.`category_id` IN(103) ) AS `tmp` WHERE `product_id` IN( SELECT `product_id` FROM `oc_product_option_value` WHERE `option_value_id` IN() ) ) AS `tmp` in /home/m/m70189/doorexmoscow.ru/public_html/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/m/m70189/doorexmoscow.ru/public_html/system/library/mfilter_core.php on line 3985 Входные железные двери в Москве недорого

DOORex представляет широкий ассортимент железных входных дверей по ценам производителей. Рынок стальных дверей очень обширен. Наша компания работает с несколькими ведущими российскими производителями, чьи марки уже сами по себе являются гарантией качества. Мы не продаем двери по завышенным ценам и строго придерживаемся рекомендованных производителями розничных цен. Кроме этого объемы продаж нашего магазина позволяют предлагать клиентам дополнительные скидки и приятные подарки. В настоящем разделе вы найдете около 280 моделей входных железных дверей. 

Так же на нашем сайте вы можете купить межкомнатные двери