SELECT DISTINCT p.id,p.[markaID],p.[retail_store_price],p.[Categories] FROM [products] AS p WHERE (CHARINDEX(',4,', p.categories)>0) OR ( (CHARINDEX(',167,', p.categories)>0) OR (CHARINDEX(',168,', p.categories)>0) OR (CHARINDEX(',170,', p.categories)>0) OR (CHARINDEX(',171,', p.categories)>0) OR (CHARINDEX(',245,', p.categories)>0) OR (CHARINDEX(',451,', p.categories)>0) OR (CHARINDEX(',883,', p.categories)>0) OR (CHARINDEX(',884,', p.categories)>0) OR (CHARINDEX(',908,', p.categories)>0) OR (CHARINDEX(',956,', p.categories)>0) OR (CHARINDEX(',1042,', p.categories)>0) OR (CHARINDEX(',172,', p.categories)>0) OR (CHARINDEX(',174,', p.categories)>0) OR (CHARINDEX(',187,', p.categories)>0) OR (CHARINDEX(',963,', p.categories)>0) OR (CHARINDEX(',965,', p.categories)>0) OR (CHARINDEX(',177,', p.categories)>0) OR (CHARINDEX(',184,', p.categories)>0) OR (CHARINDEX(',185,', p.categories)>0) OR (CHARINDEX(',492,', p.categories)>0) OR (CHARINDEX(',498,', p.categories)>0) OR (CHARINDEX(',900,', p.categories)>0)) | pagerTotal=217 | filtering=False | catID=4 | kz.count=11 | title DESC | title | SELECT DISTINCT [id] FROM (SELECT Row_Number() OVER ( ORDER BY p.title DESC) AS RowIndex, p.id FROM [products] AS p WHERE p.id IN(2235,2236,2401,2413,2414,2415,2416,2437,2494,2752,2758,3398,3475,3490,3525,3603,3610,3628,3635,3641,3642,3675,3677,3722,3735,3736,3737,4170,4703,4705,4824,4843,4946,5485,5490,5491,5492,5502,5503,5504,5505,5508,5551,5879,5971,6085,6170,6779,6805,7089,7575,7688,7735,7736,7789,7827,7912,8039,8073,8074,8305,8306,8307,8359,8433,8442,8563,8666,8691,8755,8769,8813,8824,8825,8839,8927,8987,8988,9109,9135,11180,11181,11228,11229,11316,11320,11321,11322,11330,11333,11334,11335,11336,11337,11338,11339,11340,11341,11344,11345,11347,11348,11350,11353,11354,11357,11358,11365,11371,11378,11422,11447,11633,11638,11642,11643,11760,11765,11837,11920,11961,12016,12020,12060,12064,12066,12067,12068,12069,12070,12071,12073,12078,12080,12095,12096,12099,12122,12145,12146,12225,12245,12248,12305,12570,12571,12572,12573,12574,12575,12576,12577,12578,12579,12580,12581,12582,12583,12584,12586,12587,12588,12589,12590,12591,12592,12593,12594,12595,12596,12598,12599,12600,12601,12602,12603,12604,12605,12606,12607,12608,12609,12610,12611,12612,12613,12614,12615,12621,12624,12805,12811,12812,12813,13883,14904,14905,14930,14995,15033,15035,15036,15043,15066,16140,16141,16143,16144,16145,16146,16147,16148,16255,16256,16261,16541,16542)) AS Sub WHERE Sub.RowIndex >= 1 AND Sub.RowIndex <= 12;

,167,168,170,171,245,451,883,884,908,956,1042,172,174,187,963,965,177,184,185,492,498,900