SELECT DISTINCT p.id,p.[markaID],p.[retail_store_price],p.[Categories] FROM [products] AS p WHERE (CHARINDEX(',9,', p.categories)>0 OR p.categories='9') OR ( (CHARINDEX(',50,', p.categories)>0 OR p.categories='50') OR (CHARINDEX(',52,', p.categories)>0 OR p.categories='52') OR (CHARINDEX(',89,', p.categories)>0 OR p.categories='89') OR (CHARINDEX(',90,', p.categories)>0 OR p.categories='90') OR (CHARINDEX(',91,', p.categories)>0 OR p.categories='91') OR (CHARINDEX(',93,', p.categories)>0 OR p.categories='93') OR (CHARINDEX(',94,', p.categories)>0 OR p.categories='94') OR (CHARINDEX(',998,', p.categories)>0 OR p.categories='998')) | Timer 0: 1 ms | Timer 1: 98 ms | Timer 2: 11 ms | pagerTotal=53 | filtering=False | Timer 3: 1506 ms | catID=9 | kz.count=8 | title DESC | title | Timer 4: 11 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(2859,2863,2864,2888,5197,5771,5788,6995,7722,7893,8172,8241,8413,8571,8714,9075,9077,10163,10174,12201,12522,12524,12526,12527,12528,12530,12538,12539,12540,12541,12542,12543,14985,14986,14987,14988,15089,15113,16229,16252,16260,16414,16427,16437,16438,16636,16637,16638,16685,16688,16814,18956,18976)) AS Sub WHERE Sub.RowIndex >= 1 AND Sub.RowIndex <= 12;

,50,52,89,90,91,93,94,998