SELECT DISTINCT p.id,p.[markaID],p.[retail_store_price],p.[Categories] FROM [products] AS p WHERE (CHARINDEX(',27,', p.categories)>0 OR p.categories='27') OR ( (CHARINDEX(',63,', p.categories)>0 OR p.categories='63') OR (CHARINDEX(',64,', p.categories)>0 OR p.categories='64') OR (CHARINDEX(',120,', p.categories)>0 OR p.categories='120') OR (CHARINDEX(',935,', p.categories)>0 OR p.categories='935') OR (CHARINDEX(',939,', p.categories)>0 OR p.categories='939')) | Timer 0: 1 ms | Timer 1: 91 ms | Timer 2: 9 ms | pagerTotal=50 | filtering=False | Timer 3: 53 ms | catID=27 | kz.count=5 | title DESC | title | Timer 4: 18 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(2233,2234,3661,3663,4273,4322,4365,4886,5899,6362,6379,6888,8116,8603,8630,8706,8897,9067,11650,11752,11861,12106,12107,12229,12325,12326,12393,12394,12395,12396,12404,12686,12828,13828,13829,13861,13862,15098,15118,16134,16135,16207,16288,16289,16406,16534,16652,16687,16719,19011)) AS Sub WHERE Sub.RowIndex >= 1 AND Sub.RowIndex <= 12;

,63,64,120,935,939