I need a database fixed

General information for the website: We sell stuff
Database management system (DBMS): MySQL
Kind of development: Customization of existing website
Description of requirements/features: I have an oscommerce site which I updated last week, during the process an issue occured with the database table and I am getting the following error:

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

select banners_id, banners_title, banners_image, banners_group, status, expires_date, expires_impressions, date_status_change, date_scheduled, date_added from banners order by banners_group, banners_title limit -0, MAX_DISPLAY_SEARCH_RESULTS_ADMIN

[TEP STOP]

I know what the issue is a simple syntax error and should take someone 20 mins to sort out if the know thier way around mySQL
Extra notes: