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 '-12, 12' at line 1/home/indianyp/ IN FILE /home/indianyp/ -

select product_code, EI_slno, product_name, checkbox_status, category_name, final_product, image_small, image_full, disp_final_page, slno, image_title, short_desc, category_type, price, qty_status, min_qty, other_site_url, other_url, anchor_title from bc_product_ei where category_name='802311' and member_id='813861' and site_type='ei' and category_type='0' and link_display='Y' and multiple_website_status='0' order by final_product, disp_final_page desc, disp_order limit -12, 12