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 'GROUP BY var.variation_id ORDER BY vard.name ASC' at line 8
Error No: 1064
SELECT var.variation_id,vard.name,vard.description,vard.seo FROM product p LEFT JOIN product_variation pv ON (p.product_id = pv.product_id) LEFT JOIN variation var ON (pv.variation_id = var.variation_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN variation_description vard ON (vard.variation_id = var.variation_id) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) LEFT JOIN product_variation ocasion ON (p.product_id = ocasion.product_id) LEFT JOIN product_variation catalog ON (p.product_id = catalog.product_id) WHERE var.variation_id = pv.variation_id AND var.variation_id = vard.variation_id AND p.product_id = p2s.product_id AND p.product_id = pd.product_id AND pv.product_id = p.product_id AND p.product_id = p2c.product_id AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND var.variation_group_id = '21' AND p.quantity != '0' AND p2c.category_id = '64' AND ocasion.variation_id = '28' AND GROUP BY var.variation_id ORDER BY vard.name ASC in /var/www/html/hopestyling.com/system/database/mmysqli.php on line 39Notice: Trying to get property 'rows' of non-object in /var/www/html/hopestyling.com/catalog/model/catalog/filter.php on line 252 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 'GROUP BY var.variation_id ORDER BY vard.name ASC' at line 8
Error No: 1064
SELECT var.variation_id,vard.name,vard.description,vard.seo FROM product p LEFT JOIN product_variation pv ON (p.product_id = pv.product_id) LEFT JOIN variation var ON (pv.variation_id = var.variation_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN variation_description vard ON (vard.variation_id = var.variation_id) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) LEFT JOIN product_variation ocasion ON (p.product_id = ocasion.product_id) LEFT JOIN product_variation catalog ON (p.product_id = catalog.product_id) WHERE var.variation_id = pv.variation_id AND var.variation_id = vard.variation_id AND p.product_id = p2s.product_id AND p.product_id = pd.product_id AND pv.product_id = p.product_id AND p.product_id = p2c.product_id AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND var.variation_group_id = '8' AND p.quantity != '0' AND p2c.category_id = '64' AND ocasion.variation_id = '28' AND GROUP BY var.variation_id ORDER BY vard.name ASC in /var/www/html/hopestyling.com/system/database/mmysqli.php on line 39Notice: Trying to get property 'rows' of non-object in /var/www/html/hopestyling.com/catalog/model/catalog/filter.php on line 252 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 'GROUP BY var.variation_id ORDER BY vard.name ASC' at line 8
Error No: 1064
SELECT var.variation_id,vard.name,vard.description,vard.seo FROM product p LEFT JOIN product_variation pv ON (p.product_id = pv.product_id) LEFT JOIN variation var ON (pv.variation_id = var.variation_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN variation_description vard ON (vard.variation_id = var.variation_id) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) LEFT JOIN product_variation ocasion ON (p.product_id = ocasion.product_id) LEFT JOIN product_variation catalog ON (p.product_id = catalog.product_id) WHERE var.variation_id = pv.variation_id AND var.variation_id = vard.variation_id AND p.product_id = p2s.product_id AND p.product_id = pd.product_id AND pv.product_id = p.product_id AND p.product_id = p2c.product_id AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND var.variation_group_id = '9' AND p.quantity != '0' AND p2c.category_id = '64' AND ocasion.variation_id = '28' AND GROUP BY var.variation_id ORDER BY vard.name ASC in /var/www/html/hopestyling.com/system/database/mmysqli.php on line 39Notice: Trying to get property 'rows' of non-object in /var/www/html/hopestyling.com/catalog/model/catalog/filter.php on line 252 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 'GROUP BY var.variation_id ORDER BY vard.name ASC' at line 8
Error No: 1064
SELECT var.variation_id,vard.name,vard.description,vard.seo FROM product p LEFT JOIN product_variation pv ON (p.product_id = pv.product_id) LEFT JOIN variation var ON (pv.variation_id = var.variation_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN variation_description vard ON (vard.variation_id = var.variation_id) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) LEFT JOIN product_variation ocasion ON (p.product_id = ocasion.product_id) LEFT JOIN product_variation catalog ON (p.product_id = catalog.product_id) WHERE var.variation_id = pv.variation_id AND var.variation_id = vard.variation_id AND p.product_id = p2s.product_id AND p.product_id = pd.product_id AND pv.product_id = p.product_id AND p.product_id = p2c.product_id AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND var.variation_group_id = '11' AND p.quantity != '0' AND p2c.category_id = '64' AND ocasion.variation_id = '28' AND GROUP BY var.variation_id ORDER BY vard.name ASC in /var/www/html/hopestyling.com/system/database/mmysqli.php on line 39Notice: Trying to get property 'rows' of non-object in /var/www/html/hopestyling.com/catalog/model/catalog/filter.php on line 252 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 'GROUP BY var.variation_id ORDER BY vard.name ASC' at line 8
Error No: 1064
SELECT var.variation_id,vard.name,vard.description,vard.seo FROM product p LEFT JOIN product_variation pv ON (p.product_id = pv.product_id) LEFT JOIN variation var ON (pv.variation_id = var.variation_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN variation_description vard ON (vard.variation_id = var.variation_id) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) LEFT JOIN product_variation ocasion ON (p.product_id = ocasion.product_id) LEFT JOIN product_variation catalog ON (p.product_id = catalog.product_id) WHERE var.variation_id = pv.variation_id AND var.variation_id = vard.variation_id AND p.product_id = p2s.product_id AND p.product_id = pd.product_id AND pv.product_id = p.product_id AND p.product_id = p2c.product_id AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND var.variation_group_id = '12' AND p.quantity != '0' AND p2c.category_id = '64' AND ocasion.variation_id = '28' AND GROUP BY var.variation_id ORDER BY vard.name ASC in /var/www/html/hopestyling.com/system/database/mmysqli.php on line 39Notice: Trying to get property 'rows' of non-object in /var/www/html/hopestyling.com/catalog/model/catalog/filter.php on line 252 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 'GROUP BY var.variation_id ORDER BY vard.name ASC' at line 8
Error No: 1064
SELECT var.variation_id,vard.name,vard.description,vard.seo FROM product p LEFT JOIN product_variation pv ON (p.product_id = pv.product_id) LEFT JOIN variation var ON (pv.variation_id = var.variation_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN variation_description vard ON (vard.variation_id = var.variation_id) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) LEFT JOIN product_variation ocasion ON (p.product_id = ocasion.product_id) LEFT JOIN product_variation catalog ON (p.product_id = catalog.product_id) WHERE var.variation_id = pv.variation_id AND var.variation_id = vard.variation_id AND p.product_id = p2s.product_id AND p.product_id = pd.product_id AND pv.product_id = p.product_id AND p.product_id = p2c.product_id AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND var.variation_group_id = '13' AND p.quantity != '0' AND p2c.category_id = '64' AND ocasion.variation_id = '28' AND GROUP BY var.variation_id ORDER BY vard.name ASC in /var/www/html/hopestyling.com/system/database/mmysqli.php on line 39Notice: Trying to get property 'rows' of non-object in /var/www/html/hopestyling.com/catalog/model/catalog/filter.php on line 252 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 'GROUP BY var.variation_id ORDER BY vard.name ASC' at line 8
Error No: 1064
SELECT var.variation_id,vard.name,vard.description,vard.seo FROM product p LEFT JOIN product_variation pv ON (p.product_id = pv.product_id) LEFT JOIN variation var ON (pv.variation_id = var.variation_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN variation_description vard ON (vard.variation_id = var.variation_id) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) LEFT JOIN product_variation ocasion ON (p.product_id = ocasion.product_id) LEFT JOIN product_variation catalog ON (p.product_id = catalog.product_id) WHERE var.variation_id = pv.variation_id AND var.variation_id = vard.variation_id AND p.product_id = p2s.product_id AND p.product_id = pd.product_id AND pv.product_id = p.product_id AND p.product_id = p2c.product_id AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND var.variation_group_id = '19' AND p.quantity != '0' AND p2c.category_id = '64' AND ocasion.variation_id = '28' AND GROUP BY var.variation_id ORDER BY vard.name ASC in /var/www/html/hopestyling.com/system/database/mmysqli.php on line 39Notice: Trying to get property 'rows' of non-object in /var/www/html/hopestyling.com/catalog/model/catalog/filter.php on line 252