Cosplay Shoes


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 7
in:
[select distinct 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 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 pd.language_id = '1' and p2c.categories_id IN(198,661,1028,1247,1285,736,877,406,150,509,1207,103,1323,1276,1283,662,904,759,1402,663,518,1075,738,1327,1100,1208,763,664,665,533,80,1455,1400,326,1404,1282,666,393,151,517,140,82,667,1418,83,1003,668,125,366,209,516,526,392,1399,144,399,670,758,208,739,407,84,85,520,1284,1407,145,1419,671,672,1326,86,673,674,458,146,199,87,697,886,1273,1245,675,149,456,1406,513,1401,1074,510,885,733,1002,134,1242,1425,1209,1250,1004,676,124,1408,1249,88,1470,734,737,677,678,761,1324,119,735,1427,1101,143,1133,1428,515,679,1608,680,681,1453,1030,1454,123,121,726,1398,682,881,760,253,142,764,1000,135,374,1609,271,1102,683,519,684,511,1243,327,1029,1274,903,1403,1322,102,1248,1073,117,685,687,207,688,1452,122,1001,879,689,690,252,1244,740,136,884,1275,1325,691,692,693,386,694,1426,741,1251,455,695,696,394,512,1429,698,699,1072,700,395,338,138,701,762,1286,686,365,1246,702,141,1077,1397,525,703,454,1451,120,704,400,457,514,398,882,118,1076,705,95,880,706,707,883,308,1405,732,397,396,708,1396) limit -0, MAX_DISPLAY_PRODUCTS_LISTING]