select * from nproducts where publish='y' and id in (0,12289,1631,1632,1633,1642,1645,1678,1692,1703,1719,1750,1755,1756,1757,1758,1760,1788,1789,1795,1799,1800,1838,1839,1840,1884,1885,1888,1889,8077,2001,2045,2054,2055,2078,2080,2081,2082,2083,2085,2086,2157,2158,2159,2248,2254,2256,2299,2298,2300,2301,2302,2303,7685,2560,2786,2787,2788,2911,2912,2913,2915,2916,2925,2928,2931,2945,5614,3488,3539,3544,3578,3607,3714,3806,3840,3841,3940,4224,4267,4353,4518,4534,4547,4548,4676,4680,4711,4730,4731,4746,4752,4754,4755,4756,4757,4782,4837,4847,4848,5094,5095,5096,5097,5098,5099,5100,5101,5102,5103,5104,5105,5106,5107,5111,5112,5119,5120,5121,5129,5213,5214,5219,5221,5228,5230,5235,5250,5257,5289,5290,5295,5337,5338,5357,5571,5574,5643,5645,5646,5650,5676,5677,5678,5685,5719,5720,5721,5722,5723,5732,5738,5753,5812,5836,5841,5844,5846,5847,5854,5855,5875,5876,5960,5962,5964,5965,6147,6161,6183,6202,6209,6210,6226,6227,6236,6239,6246,6275,6286,6287,6288,6296,6297,6316,6332,6341,6342,6349,6367,6368,6369,6371,6383,6384,6385,6386,6395,6396,6397,6398,6399,6400,6401,6402,6403,6646,6931,6960,6961,6962,6968,7001,7118,7217,7218,7219,7220,7234,7244,7262,7263,7302,7316,7319,7324,7325,7377,7378,7379,7385,7387,7389,7443,7492,7493,7507,7508,7509,7510,7511,7512,7513,7514,7515,7516,7526,7527,7528,7530,7531,7532,7533,7573,7630,7632,7634,7635,7637,7638,7639,7640,7648,7656,7657,7662,7679,7872,7873,7966,8079,8216,8217,8218,8228,8229,8230,8240,8241,8242,8246,8247,8263,8282,8330,8331,8338,8353,8357,8358,8359,8361,8372,8373,8388,8389,8399,8400,8410,8411,8412,8437,8442,8446,8453,8454,8582,8598,8599,8600,8601,8611,8622,8623,8627,8628,8629,8650,8665,8666,8667,8668,8679,8680,8681,8682,8717,8748,8758,8763,8764,8769,8770,8771,8795,8796,8809,8811,8857,8859,8860,8861,9054,9059,9109,9153,9167,9173,10275,9266,9268,9272,9273,9622,9624,9661,9662,9709,9713,9744,9745,9746,9747,9749,9818,9819,9834,9835,9836,9837,9838,9839,9840,9841,9842,9843,9915,9926,9929,9930,9931,9932,9957,9961,9968,9976,10076,10059,10003,10005,10021,10022,10038,10042,10043,10048,10158,10177,10178,10192,10198,10222,10226,10258,10259,10266,10267,10268,10269,10270,10271,10272,10273,10274,10276,10278,10279,10292,10310,10311,10312,10313,10314,10431,10455,10463,10468,10469,10490,10521,10545,10546,10547,10556,10560,10574,10575,10581,10582,10583,10584,10599,10602,10616,10619,10666,10668,10669,10670,10671,10672,10673,10677,10731,10733,10761,10767,10780,10781,10782,10783,10809,10890,10891,10892,10893,10973,10996,11057,11079,11080,11081,11082,11169,11170,11171,11300,11301,11302,11303,11304,11305,11306,11307,11308,11327,11328,11329,11358,11364,11378,11387,11388,11396,11397,11527,11528,11529,11530,11541,11544,11628,11629,11658,11684,11686,11687,11698,11699,11700,11701,11702,11703,11704,11732,11733,11735,11811,11812,11813,11814,11815,11816,11878,11879,12854,11922,11941,11942,11943,11944,11945,11946,11947,11948,11949,11950,11951,11952,11953,11954,11955,11956,11957,11958,11959,11960,11961,11963,11962,11964,11965,11966,11967,12001,12002,12016,12019,12024,12025,12026,12033,12041,12054,12055,12063,12082,12083,12146,12149,12288,12306,12307,12373,12544,12818,12843,12844,12846,12847,12848,12849,12850,12851,12852,12853,12856,12857,12873,12882,12883,12884,12910,12911,12912,12938,12939,12940,12941,12985,12986,12987) and brand_id=136 order by nproducts.id desc LIMIT 0, 331