select * from nproducts where publish='y' and id in (0,1456,1461,1462,1463,1464,1465,1466,1471,1472,1473,1474,1475,1476,1477,1478,1479,1480,1484,1487,1488,1492,1494,1498,1500,2304,2305,2306,2307,2308,2309,2310,2311,2312,2313,2314,2315,2321,2322,2323,2324,2325,2326,2327,2328,2329,2330,2331,2332,2333,2334,2335,2365,2367,2616,4333,4917,4935,4936,4938,4940,4941,4942,4943,4945,4946,4948,4949,4950,4951,4952,4953,4954,4955,4956,4961,4964,4965,4966,5477,5478,5479,5480,5481,5491,5492,5493,5494,5495,5496,5497,5498,5499,5500,5501,5502,5503,5509,5510,5511,5519,7537,11448,11449) and brand_id=48 order by nproducts.id desc LIMIT 0, 331