<div class="systemError">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 'order by p.products_date_added DESC, pd.products_name
                         ' at line 12<br />in:<br />[SELECT DISTINCT p.products_id, pd.products_name, pd.products_description, p.products_image, GREATEST(p.products_date_added, IFNULL(p.products_last_modified, 0)) AS products_date, p.master_categories_id, p.products_price_sorter AS price, p.products_tax_class_id, p.products_quantity, p.products_model, p.products_weight, p.manufacturers_id, m.manufacturers_name, r.reviews_rating
                       FROM products p
                         LEFT JOIN products_description pd ON (p.products_id = pd.products_id)
                         LEFT JOIN manufacturers m ON (p.manufacturers_id = m.manufacturers_id)
                         LEFT JOIN reviews r ON (p.products_id = r.products_id)
                         
                       WHERE pd.language_id = 1
                         AND p.products_status = 1
                         
                          order by p.products_id desc limit 1000
                         
                          order by p.products_date_added DESC, pd.products_name
                          LIMIT 100]<br /></div>