Для коттеджа

Для освещение загороднего дома годятся почти все светильники представленные на сайте, однако нам хотелось бы отметить некоторые из них ...

1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-0, 0' at line 7
in:
[select m.manufacturers_name, p.products_image, pd.products_name, p.products_quantity, p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status from zet_products_description pd, zet_products p left join zet_manufacturers m on p.manufacturers_id = m.manufacturers_id, zet_products_to_categories p2c left join zet_specials s on p2c.products_id = s.products_id where p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '2' and p2c.categories_id = '114' order by m.manufacturers_name , pd.products_name limit -0, 0]