SELECT DISTINCT p.id,p.[markaID],p.[retail_store_price],p.[Categories] FROM [products] AS p WHERE (CHARINDEX(',4,', p.categories)>0 OR p.categories='4') OR ( (CHARINDEX(',167,', p.categories)>0 OR p.categories='167') OR (CHARINDEX(',168,', p.categories)>0 OR p.categories='168') OR (CHARINDEX(',170,', p.categories)>0 OR p.categories='170') OR (CHARINDEX(',171,', p.categories)>0 OR p.categories='171') OR (CHARINDEX(',245,', p.categories)>0 OR p.categories='245') OR (CHARINDEX(',451,', p.categories)>0 OR p.categories='451') OR (CHARINDEX(',883,', p.categories)>0 OR p.categories='883') OR (CHARINDEX(',884,', p.categories)>0 OR p.categories='884') OR (CHARINDEX(',908,', p.categories)>0 OR p.categories='908') OR (CHARINDEX(',956,', p.categories)>0 OR p.categories='956') OR (CHARINDEX(',172,', p.categories)>0 OR p.categories='172') OR (CHARINDEX(',174,', p.categories)>0 OR p.categories='174') OR (CHARINDEX(',187,', p.categories)>0 OR p.categories='187') OR (CHARINDEX(',963,', p.categories)>0 OR p.categories='963') OR (CHARINDEX(',965,', p.categories)>0 OR p.categories='965') OR (CHARINDEX(',1066,', p.categories)>0 OR p.categories='1066') OR (CHARINDEX(',177,', p.categories)>0 OR p.categories='177') OR (CHARINDEX(',184,', p.categories)>0 OR p.categories='184') OR (CHARINDEX(',185,', p.categories)>0 OR p.categories='185') OR (CHARINDEX(',492,', p.categories)>0 OR p.categories='492') OR (CHARINDEX(',498,', p.categories)>0 OR p.categories='498') OR (CHARINDEX(',900,', p.categories)>0 OR p.categories='900')) | Timer 0: 1 ms | Timer 1: 328 ms | Timer 2: 24 ms | pagerTotal=235 | filtering=False | Timer 3: 395 ms | catID=4 | kz.count=10 | title DESC | title | Timer 4: 76 ms | 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,2437,2494,2650,2651,2684,2752,2758,3385,3490,3525,3603,3610,3628,3634,3635,3641,3642,3675,3677,3722,3735,3736,3737,4703,4705,4824,4843,4946,5485,5490,5491,5492,5502,5503,5504,5505,5508,5551,5576,5879,5971,6085,6170,6318,6779,6805,7089,7575,7688,7735,7736,7789,7827,7912,8039,8073,8074,8305,8306,8307,8359,8433,8442,8563,8691,8755,8769,8813,8824,8825,8839,8927,8987,8988,9109,9135,11180,11181,11228,11229,11316,11320,11321,11322,11327,11330,11333,11334,11335,11336,11337,11338,11339,11340,11341,11344,11345,11347,11348,11350,11353,11354,11357,11358,11365,11371,11378,11421,11422,11447,11638,11642,11643,11760,11765,11837,11920,11961,12016,12020,12060,12063,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,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,14992,14994,14995,15033,15035,15036,15040,15043,15066,16140,16141,16142,16143,16144,16145,16146,16147,16148,16255,16256,16261,16397,16467,16541,16542,16635,16670,16721,16733,16734,16739,16740,16741,16797,16808)) AS Sub WHERE Sub.RowIndex >= 1 AND Sub.RowIndex <= 12;

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