select * from tblproducts where producttype=0 and isactive=1 and pid in (0,1871,1870,1869,1868,1867,1866,1865,1864,1863,1862,1861,1860,1859,1858,1857,1856,1855,1854,1853,1852,1851,1850,1849,1480,1479,1478,1477,1476,1475,1474,1473,1472,1471,1470,1469,1468,1467,1466,1465,1464,1463,1462,1461,1460,1459,1458,1457,1456,1455,1454,1453,1452,1451,1449,1448,1447,1446,1445,1444,1443,1442,1441,1439,1438,1437,1436,1435,1434,1432,1012,1012,824,812,809,785,783,780,770,763,762,732,730,712,696,690,684,148,140,135,131,130,128,126,126,123,123,120,120,119,118,114,48,46,43,31,30,22,21,20,19,16,15,139) order by FIELD(pid,0,1871,1870,1869,1868,1867,1866,1865,1864,1863,1862,1861,1860,1859,1858,1857,1856,1855,1854,1853,1852,1851,1850,1849,1480,1479,1478,1477,1476,1475,1474,1473,1472,1471,1470,1469,1468,1467,1466,1465,1464,1463,1462,1461,1460,1459,1458,1457,1456,1455,1454,1453,1452,1451,1449,1448,1447,1446,1445,1444,1443,1442,1441,1439,1438,1437,1436,1435,1434,1432,1012,1012,824,812,809,785,783,780,770,763,762,732,730,712,696,690,684,148,140,135,131,130,128,126,126,123,123,120,120,119,118,114,48,46,43,31,30,22,21,20,19,16,15,139) limit -16,16
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 '-16,16' at line 1
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 '-16,16' at line 1