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 ')) WHERE pv2p.param_value_id = '945' GROUP BY p.product_id HAVING (count_par = 1' at line 5
Error No: 1064
SELECT pv2p.product_id, COUNT(DISTINCT pv2p.param_value_id) AS count_par, GROUP_CONCAT(DISTINCT pv2p.param_value_id) AS group_param FROM param_value_to_product pv2p INNER JOIN product p ON (p.product_id = pv2p.product_id) INNER JOIN product_to_category p2c ON (p2c.product_id = p.product_id AND p2c.category_id IN ()) WHERE pv2p.param_value_id = '945' GROUP BY p.product_id HAVING (count_par = 1) in /var/www/market.tricolor.com.ua/system/library/db/mysqli.php on line 49Notice: Trying to get property 'rows' of non-object in /var/www/market.tricolor.com.ua/catalog/model/catalog/tag.php on line 168Warning: Invalid argument supplied for foreach() in /var/www/market.tricolor.com.ua/catalog/model/catalog/tag.php on line 168Notice: 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 ')) WHERE pv2p.param_value_id = '945' GROUP BY p.product_id HAVING (count_par = 1' at line 5
Error No: 1064
SELECT pv2p.product_id, COUNT(DISTINCT pv2p.param_value_id) AS count_par, GROUP_CONCAT(DISTINCT pv2p.param_value_id) AS group_param FROM param_value_to_product pv2p INNER JOIN product p ON (p.product_id = pv2p.product_id) INNER JOIN product_to_category p2c ON (p2c.product_id = p.product_id AND p2c.category_id IN ()) WHERE pv2p.param_value_id = '945' GROUP BY p.product_id HAVING (count_par = 1) in /var/www/market.tricolor.com.ua/system/library/db/mysqli.php on line 49Notice: Trying to get property 'rows' of non-object in /var/www/market.tricolor.com.ua/catalog/model/catalog/tag.php on line 168Warning: Invalid argument supplied for foreach() in /var/www/market.tricolor.com.ua/catalog/model/catalog/tag.php on line 168 Формы для гипсовой плитки: купить форму для плитки из гипса - цены от Триколор