limiting products properly in products_new

[ganz_friedrich]

Hi,

[I wouldn't be surprised if this query has been delt with a million times but my luck I can't find one - so apologies in advance]

I want to limit the products in products_new.php to the last 20 products added. However simply applying the limit at the end of the query causes a problem because another limit is made immediately after due to the page splitting class.

The error is:

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 'limit 0, 10' at line 1

select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name from products p left join manufacturers m on (p.manufacturers_id = m.manufacturers_id), products_description pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_date_added DESC, pd.products_name limit 0, 20 limit 0, 10

(by the way, originally the products are limited to the current month - in any year. So if you added products in June last year then they'll be listed today).

Thanks