SELECT DISTINCT p.id,p.[markaID],p.[retail_store_price],p.[Categories] FROM [products] AS p WHERE (CHARINDEX(',221,', p.categories)>0 OR p.categories='221') OR ( (CHARINDEX(',225,', p.categories)>0 OR p.categories='225') OR (CHARINDEX(',279,', p.categories)>0 OR p.categories='279') OR (CHARINDEX(',888,', p.categories)>0 OR p.categories='888') OR (CHARINDEX(',892,', p.categories)>0 OR p.categories='892')) | Timer 0: 1 ms | Timer 1: 53 ms | Timer 2: 4 ms | pagerTotal=39 | filtering=False | Timer 3: 3533 ms | catID=221 | kz.count=4 | title DESC | title | Timer 4: 6 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(3289,3392,5464,6690,7265,7266,7268,7391,7572,7696,7697,7783,8944,8945,11547,11551,11552,12129,12141,12156,12758,12760,12761,12762,12763,12764,12765,12766,12767,12768,12770,15080,16476,16477,16554,16555,16556,16557,16820)) AS Sub WHERE Sub.RowIndex >= 1 AND Sub.RowIndex <= 12;

,225,279,888,892