select * from tblproducts where producttype=0 and isactive=1 and pid in (0,1935,1934,1933,1932,1931,1930,1929,1928,1927,1926,1925,1924,1923,1922,1921,1920,1919,1918,1915,1903,1902,1901,1900,1899,1898,1897,1896,1895,1894,1893,1892,1891,1890,1889,1888,1887,1886,1885,1884,1883,1882,829,828,827,820,807,802,800,798,797,796,795,794,792,775,774,769,759,758,757,756,755,754,753,752,750,749,748,747,746,726,723,720,695,693,692,691,689,677,675,664,647,642,636,628,616,615,599,597,592,587,585,584,579,570,565,563,556,549,548,544,539,538,537,534,533,529,523,508,504,490,477,464,461,447,446,439,435,429,425,420,415,410,409,405,404,397,387,374,364,355,350,347,345,335,307,301,300,297,293,292,284,278,262,237,236,201,180,175,161,160,151,137,129,115,113,110,109,103,99,87,80,75,65,64,61,57,56,55,53,45,41,38,37,125,384,127) order by FIELD(pid,0,1935,1934,1933,1932,1931,1930,1929,1928,1927,1926,1925,1924,1923,1922,1921,1920,1919,1918,1915,1903,1902,1901,1900,1899,1898,1897,1896,1895,1894,1893,1892,1891,1890,1889,1888,1887,1886,1885,1884,1883,1882,829,828,827,820,807,802,800,798,797,796,795,794,792,775,774,769,759,758,757,756,755,754,753,752,750,749,748,747,746,726,723,720,695,693,692,691,689,677,675,664,647,642,636,628,616,615,599,597,592,587,585,584,579,570,565,563,556,549,548,544,539,538,537,534,533,529,523,508,504,490,477,464,461,447,446,439,435,429,425,420,415,410,409,405,404,397,387,374,364,355,350,347,345,335,307,301,300,297,293,292,284,278,262,237,236,201,180,175,161,160,151,137,129,115,113,110,109,103,99,87,80,75,65,64,61,57,56,55,53,45,41,38,37,125,384,127) 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