SELECT DISTINCT p.id,p.[markaID],p.[retail_store_price],p.[Categories] FROM [products] AS p WHERE (CHARINDEX(',1068,', p.categories)>0 OR p.categories='1068') | Timer 0: 1 ms | Timer 1: 28 ms | Timer 2: 7 ms | pagerTotal=74 | filtering=False | Timer 3: 1934 ms | catID=1068 | kz.count=0 | title DESC | title | Timer 4: 31 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(3841,3925,3950,3996,3997,3999,4000,4016,4018,4020,5008,5262,6710,7907,12401,12402,12408,12409,12410,12411,12413,12414,12415,12416,12417,12418,12419,12420,12421,12422,12423,12424,12425,12426,12427,12428,12429,12430,12431,12432,12433,12434,12435,12436,12438,12440,12441,12442,12443,12445,12446,12448,12452,12531,12532,12533,12618,12730,15055,15058,15126,16182,16213,16214,16441,16461,16462,16463,16464,16485,16711,16743,16753,16804)) AS Sub WHERE Sub.RowIndex >= 1 AND Sub.RowIndex <= 12;