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 '-10, 10' at line 1
select p.products_id, p.*, pd.* from products p, products_description pd, products_to_categories pc, categories c where p.products_id=pc.products_id and pd.products_id=pc.products_id and p.products_status=1 and pc.categories_id = c.categories_id and c.categories_status = 1 and pc.categories_id in (271) order by p.products_price asc limit -10, 10