Cosplay Wigs


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(1552,540,224,1571,748,1562,1128,1496,300,1569,1498,1515,1127,1523,819,216,1378,1658,1148,1516,749,461,1315,1563,1129,101,426,345,750,1048,1499,1657,445,1376,1550,114,1565,115,1047,1126,1320,104,1514,349,543,1656,302,751,284,1462,275,1661,155,1555,105,1578,1050,116,1130,1379,1509,535,1648,290,390,1650,1520,447,276,313,152,1313,542,282,451,285,1662,111,436,1547,539,217,1512,1316,719,752,1495,444,248,538,1518,1317,1307,218,1505,1311,1204,1504,1309,168,1556,541,1306,1567,106,1506,350,537,753,754,1318,1572,301,225,1577,174,1566,1049,431,717,281,446,1519,1507,1046,1551,113,108,1573,449,434,1375,1570,247,1131,314,1503,1554,107,1582,211,279,1654,1564,1308,311,312,1497,1203,1310,1549,126,1500,109,715,1511,439,1521,1647,440,1665,437,1510,536,286,1580,236,755,344,1655,291,1508,1502,1460,435,1319,756,438,1459,1546,1380,716,1381,1581,280,1522,1659,346,278,348,1548,1456,277,1461,714,299,112,283,450,757,425,110,169,1377,1517,1533,1513,1649,1553,1663,1501,1568,1312,1646,1557,1321) limit -0, MAX_DISPLAY_PRODUCTS_LISTING]