select * from nproducts where publish='y' and id in (0,1434,1961,1435,1436,1437,1438,1439,1440,1441,1442,1443,1444,1445,1446,1450,1451,1452,1453,1536,1537,1538,1933,1957,2369,2370,2468,2469,2470,2471,2472,2473,2474,2475,2476,2477,2478,2497,2498,2499,2500,2504,2505,2506,2507,2508,2509,2510,2511,2512,2617,2618,2619,2659,2698,2699,2708,2709,2756,3756,3757,3758,3759,3760,3761,3762,3763,4298,4449,4451,4457,5086,5087,5088,5089,6061,5405,5406,5895,5896,5897,5900,5909,5910,5911,5917,5918,5919,5920,5921,5922,5923,5924,5925,5926,5927,6062,6065,6066,6067,6068,6069,6070,6071,6072,6073,6074,7047,7048,7049,7050,7058,7059,7060,7061,7099,7100,7101,8868,8869,8870,8871,8872,8873,8874,8875,8876,8877,8878,8879,8880,8881,8882,8883,8884,8885,8886,8887,8888,8889,8890,8891,8995,8961,8964,8965,8966,8984,8985,8986,8987,8988,8989,8990,8991,8992,8993,8994,8996,8997,8998,8999,9000,9001,9002,9003,9004,9005,9006,9007,9008,9009,9010,9011,9012,9013,9014,9015,9016,9017,9018,9019) and brand_id=47 order by nproducts.id desc LIMIT 0, 331