SELECT DISTINCT p.id,p.[markaID],p.[retail_store_price],p.[Categories] FROM [products] AS p WHERE (CHARINDEX(',13,', p.categories)>0 OR p.categories='13') OR ( (CHARINDEX(',140,', p.categories)>0 OR p.categories='140') OR (CHARINDEX(',1068,', p.categories)>0 OR p.categories='1068')) | Timer 0: 1 ms | Timer 1: 51 ms | Timer 2: 1 ms | pagerTotal=87 | filtering=False | Timer 3: 844 ms | catID=13 | kz.count=2 | title DESC | title | Timer 4: 21 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,5290,5542,6710,7769,7907,8633,8634,8635,11882,12262,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,12433,12434,12435,12436,12437,12438,12440,12441,12442,12443,12444,12445,12446,12448,12451,12452,12531,12532,12533,12618,12730,15055,15058,15126,16182,16213,16214,16441,16461,16462,16463,16464,16485,16492,16522,16523,16711,16743,16753,16804)) AS Sub WHERE Sub.RowIndex >= 1 AND Sub.RowIndex <= 12;

,140,1068