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 'limit 0,8' at line 1
in:
[select p.products_id, p.products_image,p.products_price,p.products_tax_class_id from products p inner join products_to_categories p2c on p.products_id=p2c.products_id where p.products_status = '1' and p2c.categories_id = limit 0,8]