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 20, 20' at line 13 from 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 20, 20' at line 13

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 INNER JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id WHERE p.products_status = 1 AND pd.language_id = 1 AND m.manufacturers_id = 1 GROUP BY p.products_id ORDER BY p. DESC, p., pd.products_name LIMIT 20, 20

[PHOENIX FATAL]