Mysql problem


#1

I just did a test run through my site and it let me purchase a product and receive it so thats a good thing. the problem is when i went to my admin area to review customers and purchases, this is the error that came up. You guys have helped me greatly so far, can ya maybe get me out of this bind?

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 ‘-20, 20’ at line 1

select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.orders_status = s.orders_status_id and s.language_id = ‘1’ and s.orders_status_id = ‘0’ and ot.class = ‘ot_total’ order by o.orders_id DESC limit -20, 20

Sincerely,
Pat1l