Cosplay Costumes


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(69,1039,709,1018,1103,878,295,1361,591,766,418,453,1038,592,823,640,255,817,836,463,998,593,831,1034,270,331,1149,240,1539,139,811,186,44,185,594,595,159,1082,1089,1044,1336,1538,1392,468,851,532,2,1078,353,315,856,1006,1025,1031,373,1045,442,1041,596,256,306,32,330,857,597,40,1007,178,3,1088,476,598,652,5,710,1055,1232,848,4,846,742,599,6,404,66,824,1241,1411,274,993,163,230,825,601,602,188,242,853,603,257,604,364,1217,1062,7,8,1465,605,1026,1035,9,10,1064,137,1363,837,530,870,68,244,1165,1083,1338,720,11,1008,1011,1466,606,212,743,441,184,608,43,41,872,166,1005,868,61,607,828,609,610,33,153,611,522,158,171,1071,1021,612,1009,718,258,521,12,1410,1040,711,767,78,1033,384,1042,613,1335,839,260,60,1358,847,36,614,991,1081,1043,615,1010,173,13,616,617,618,529,1468,227,1332,855,619,1366,272,154,840,262,1617,813,1014,1012,852,994,303,263,1015,157,620,51,830,1389,67,1016,1017,156,621,622,433,424,305,999,180,473,623,1529,1032,989,343,624,625,1618,372,429,1058,172,845,864,378,874,323,1337,1020,14,835,996,1636,712,838,1339,1364,1022,1260,1112,316,626,627,187,1463,768,863,1024,202,628,629,15,1531,70,288,1065,42,1544,531,528,827,94,65,869,16,630,821,1301,826,304,1090,632,631,37,544,162,388,633,1281,854,179,17,634,1152,470,18,160,189,635,713,744,873,832,862,636,183,1450,20,261,600,637,638,1060,264,267,1079,745,639,377,1054,997,641,213,642,995,387,643,333,177,644,1052,1053,235,1087,265,992,1334,746,19,747,833,176,986,432,181,822,645,443,1532,175,850,170,646,238,647,849,1019,1328,1092,320,245,843,1051,1063,648,318,875,259,332,649,865,650,268,651,72,1537,371,1280,769,654,203,653,1613,655,376,243,210,71,1057,269,448,1107,1595,1061,402,164,1202,21,656,1059,45,462,1023,1391,1091,657,871,829,658,1093,237,834,464,1365,659,161,319,340,1185,660) limit -0, MAX_DISPLAY_PRODUCTS_LISTING]