Warning : DB: [1064] 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 'DESC, p., pd.products_name LIMIT 0, 20' at line 14 from
/home/v10l1nsl0v3rc0m/public_html/includes/system/versioned/1.0.8.1/database_core.php on line 44
Warning : ORDER BY p. DESC, p., pd.products_name LIMIT 0, 20> in /home/v10l1nsl0v3rc0m/public_html/includes/system/versioned/1.0.8.1/database_core.php on line 44
1064 - 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 'DESC, p., pd.products_name LIMIT 0, 20' at line 14 SELECT p.*, pd.*, m.*,
IF(s.status, s.specials_new_products_price, NULL) AS specials_new_products_price,
IF(s.status, s.specials_new_products_price, p.products_price) AS final_price,
p.products_quantity AS in_stock,
COALESCE(AVG(r.reviews_rating), 0) AS averagerating,
IF(s.status, 1, 0) AS is_special
FROM
products p
LEFT JOIN specials s ON p.products_id = s.products_id
LEFT JOIN reviews r ON r.products_id = p.products_id
INNER JOIN products_description pd ON p.products_id = pd.products_id LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id
INNER JOIN products_to_categories p2c
WHERE p.products_status = 1 AND p.products_id = p2c.products_id AND pd.products_id = p2c.products_id AND pd.language_id = 1 AND p2c.categories_id = 174 GROUP BY p.products_id ORDER BY p. DESC, p., pd.products_name LIMIT 0, 20[PHOENIX FATAL]