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 '-24, 24' at line 11

SELECT * FROM products p, products_description pd, products_to_categories p2c, categories c where c.categories_status='1' and p.products_id = p2c.products_id and p.products_id=pd.products_id and p2c.categories_id = c.categories_id and c.parent_id IN (1030) and p.products_status = '1' and pd.language_id = '2' GROUP BY p.products_id ORDER BY p.products_order ASC, p.products_price ASC LIMIT -24, 24

[XT SQL Error]