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_FEATURED_PRODUCTS' at line 8 in: [SELECT p.products_id, p.products_type, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call,
p.product_is_always_free_shipping, p.products_qty_box_status,
p.master_categories_id
FROM (zen_products p
LEFT JOIN zen_manufacturers m on (p.manufacturers_id = m.manufacturers_id), zen_products_description pd
LEFT JOIN zen_featured f on pd.products_id = f.products_id )
WHERE p.products_status = 1 and p.products_id = f.products_id and f.status = 1
AND p.products_id = pd.products_id and pd.language_id = 1 order by pd.products_name limit -0, MAX_DISPLAY_PRODUCTS_FEATURED_PRODUCTS]