SELECT DISTINCT p.id,p.[markaID],p.[retail_store_price],p.[Categories] FROM [products] AS p WHERE (CHARINDEX(',850,', p.categories)>0 OR p.categories='850') OR ( (CHARINDEX(',851,', p.categories)>0 OR p.categories='851') OR (CHARINDEX(',852,', p.categories)>0 OR p.categories='852') OR (CHARINDEX(',1044,', p.categories)>0 OR p.categories='1044')) | Timer 0: 3 ms | Timer 1: 82 ms | Timer 2: 6 ms | pagerTotal=58 | filtering=False | Timer 3: 1811 ms | catID=850 | kz.count=3 | title DESC | title | Timer 4: 8 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(2110,2361,2362,2365,2371,3210,5560,6352,6426,6427,6470,6679,6692,6733,6935,7244,7460,7461,8041,8042,8043,8062,8064,8226,8227,8698,11676,11677,11679,11869,12004,12005,12007,12008,12133,13880,14906,14907,14908,14909,14910,14911,14925,14927,15010,16149,16218,16219,16220,16221,16222,16224,16264,16512,16514,16790,16791,16793)) AS Sub WHERE Sub.RowIndex >= 1 AND Sub.RowIndex <= 12;

,851,852,1044