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, MAX_DISPLAY_PRODUCTS_LISTING' at line 16
in:
[select p.products_quantity, p.products_id, p.products_type,p.products_status,p.products_price,p.products_price_unit,p.products_price_retail,p.products_price_sample,p.product_is_wholesale,p.product_wholesale_min,p.products_quantity, p.products_quantity_order_min, p.products_quantity_order_lots, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, u.products_unit, pd.products_description, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_free_shipping_options, p.product_is_free, p.products_qty_box_status from products_description_en pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c,products_unit_en u where p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and p.products_unit_code = u.unit_code and pd.language_id = '1' and p2c.categories_id = 16 and p.products_quantity > 0 and p.products_price > 0 and (p.image_tag = 1) and (p.products_fangpin_tag = '' or p.products_fangpin_tag = 'zz') order by p.products_price_unit limit -0, MAX_DISPLAY_PRODUCTS_LISTING]