SELECT DISTINCT p.id,p.[markaID],p.[retail_store_price],p.[Categories] FROM [products] AS p WHERE (CHARINDEX(',27,', p.categories)>0) OR ( (CHARINDEX(',63,', p.categories)>0) OR (CHARINDEX(',64,', p.categories)>0) OR (CHARINDEX(',120,', p.categories)>0) OR (CHARINDEX(',935,', p.categories)>0) OR (CHARINDEX(',939,', p.categories)>0)) | pagerTotal=48 | filtering=False | catID=27 | kz.count=5 | 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(2189,2190,2201,2234,3661,3663,4273,4322,4365,4886,5899,6362,6888,7059,8116,8603,8706,8897,9067,11493,11494,11495,11496,11650,11752,11861,12106,12107,12229,12325,12326,12394,12404,12686,12828,13828,13861,13862,15098,16134,16135,16207,16288,16289,16406,16534,16652,16687)) AS Sub WHERE Sub.RowIndex >= 1 AND Sub.RowIndex <= 12;

,63,64,120,935,939