select * from nproducts where publish='y' and id in (0,842,843,844,845,846,847,2724,2725,4405,7736,6487,6488,6489,6490,6491,6492,6493,6494,6495,6496,6497,6498,6499,6500,6501,6502,6503,6504,6505,6507,6508,6509,6510,6511,6512,6513,6514,6515,6516,6517,6518,6519,6520,6629,6630,6631,6682,6691,6696,6697,6698,6699,6700,6713,6715,6716,6717,6718,6719,6720,6721,6722,6723,6724,6923,7005,6854,6861,6908,6909,6910,6911,6912,6913,6914,6915,6916,6917,6918,6980,6982,6983,6984,6985,6987,6991,6992,7006,7010,7072,7073,8585,9214,9464,11256,11180,11181,11182,11183,11184,11185,11186,11257,11258,12840,12841,12842) and brand_id=205 order by nproducts.id desc LIMIT 0, 331