SELECT DISTINCT p.id,p.[markaID],p.[retail_store_price],p.[Categories] FROM [products] AS p WHERE (CHARINDEX(',167,', p.categories)>0 OR p.categories='167') OR ( (CHARINDEX(',172,', p.categories)>0 OR p.categories='172') OR (CHARINDEX(',174,', p.categories)>0 OR p.categories='174') OR (CHARINDEX(',187,', p.categories)>0 OR p.categories='187') OR (CHARINDEX(',963,', p.categories)>0 OR p.categories='963') OR (CHARINDEX(',965,', p.categories)>0 OR p.categories='965') OR (CHARINDEX(',1066,', p.categories)>0 OR p.categories='1066')) | Timer 0: 1 ms | Timer 1: 129 ms | Timer 2: 10 ms | pagerTotal=55 | filtering=False | Timer 3: 3153 ms | catID=167 | kz.count=6 | title DESC | title | Timer 4: 16 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(2235,2236,2413,2414,2650,2651,2684,3385,3490,3635,5485,5508,5551,6318,6805,8305,8306,8433,11344,11345,11348,11350,11378,11421,11422,11638,11760,11765,12063,12078,12145,12146,12225,12575,12577,12578,12579,12580,12583,12599,12600,12624,14992,14995,15033,15040,16140,16141,16142,16256,16541,16542,16670,16733,16734)) AS Sub WHERE Sub.RowIndex >= 1 AND Sub.RowIndex <= 12;

,172,174,187,963,965,1066