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 '-0, MAX_DISPLAY_PRODUCTS_LISTING' at line 9
in:
[select distinct p.products_id,p.products_quantity, p.products_type,p.products_status,p.products_model,p.products_price,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.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description_it, 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 products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join 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 p.products_id in (336,801,823,893,1087,1329,1556,1602,1625,1642,1704,1767,1900,1915,1921,1948,1971,2080,2099,2162,2278,2281,2284,2286,2287,2289,2317,2319,2328,2350,2351,2354,2407,2408,2410,2412,2413,2865,2872,2876,2881,2884,2891,2893,2894,2904,2905,2906,2907,2908,3036,3210,3221,3222,3266,3267,3269,3271,3272,4398,4410,4420,4437,4441,4475,4529,4610,4617,4620,4745,4750,4827,5163,5168,5175,5200,5207,5224,5263,5305,5311,5312,5313,5322,5382,5424,5484,5593,5646,5734,5778,6529,6556,6566,6781,6843,7118,7183,7269,7334,7447,7523,7584,11932,11991,11995,12079,12112,12317,12405,12406,12590,12823,12866,12893,13009,13285,13539,13592,13593,13789,13790,13856,13859,13864,13899,13901,13902,13936,13999,14007,14203,14223,14298,14313,14321)
and p.products_quantity <> 0
and pd.language_id = '1'
and ( p2c.categories_id =98 or p2c.categories_id =99 or p2c.categories_id =100 or p2c.categories_id =101 or p2c.categories_id =102 or p2c.categories_id =103 or p2c.categories_id =104 or p2c.categories_id =105 or p2c.categories_id =106 or p2c.categories_id =107 or p2c.categories_id =136 or p2c.categories_id =137 or p2c.categories_id =138 or p2c.categories_id =140 or p2c.categories_id =146 or p2c.categories_id =147 or p2c.categories_id =148 or p2c.categories_id =149 or p2c.categories_id =150 or p2c.categories_id =151 or p2c.categories_id =152 or p2c.categories_id =153 or p2c.categories_id =154 or p2c.categories_id =155 or p2c.categories_id =156 or p2c.categories_id =157 or p2c.categories_id =158 or p2c.categories_id =159 or p2c.categories_id =160 or p2c.categories_id =161 or p2c.categories_id =222 or p2c.categories_id =416 or p2c.categories_id =418 or p2c.categories_id =419) order by p.products_sort_order DESC, p.products_ordered DESC, pd.products_viewed DESC, p.products_date_added DESC limit -0, MAX_DISPLAY_PRODUCTS_LISTING]