Cosplay Accessories


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(1611,1240,958,1147,770,1674,1433,411,939,842,947,771,981,945,1434,772,1158,815,1291,1295,1593,773,774,1298,775,35,776,777,984,1145,978,968,778,779,287,527,56,1109,967,974,52,973,980,298,781,925,1296,1176,1252,782,969,504,294,53,1105,976,783,964,1178,420,1386,966,76,956,1294,1383,409,784,954,785,979,786,787,57,1177,1146,1293,788,940,194,1387,972,949,206,1175,1157,47,789,941,790,948,950,1388,1110,1138,919,1304,791,1164,1299,792,793,1239,971,1080,975,794,1180,38,795,412,1610,796,797,965,55,1106,959,953,1612,798,799,800,801,1231,780,1179,54,368,413,1385,325,1669,1069,962,802,961,1166,963,946,524,803,480,239,804,977,1104,805,1108,944,937,970,195,952,806,960,1297,408,1432,1162,1382,807,982,193,297,147,951,808,955,77,943,196,809,983,938,192,1111,810,1435,1300,1670,1163) limit -0, MAX_DISPLAY_PRODUCTS_LISTING]