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 9
in:
[SELECT DISTINCT p.products_image, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.products_quantity , p.products_id, pd.products_name, p.products_price, p.products_price_unit, p.products_price_retail, p.product_is_wholesale, p.product_is_always_free_shipping,p.products_free_shipping_options,p.products_quantity_order_lots,u.products_unit,p.products_quantity_order_min, p.products_tax_class_id, p.products_price_sorter, p.products_qty_box_status, p.master_categories_id, p.image_tag FROM (products p LEFT JOIN products_unit_en u ON p.products_unit_code = u.unit_code,products_description_en pd, products_to_categories p2c ) WHERE (p.products_status = 1 and p.p_tag > 1 AND p.products_quantity > 1 AND p.products_id = pd.products_id AND pd.language_id = 1 AND p.products_id = p2c.products_id AND ((pd.products_name LIKE '%singles%') )) and (p.products_fangpin_tag = '' or p.products_fangpin_tag = 'zz') and p.image_tag = 1 and p.products_onsale = 1 order by p.products_sort_order ASC,p.products_id desc limit -0, MAX_DISPLAY_PRODUCTS_LISTING]