SELECT DISTINCT p.id,p.[markaID],p.[retail_store_price],p.[Categories] FROM [products] AS p WHERE (CHARINDEX(',171,', p.categories)>0 OR p.categories='171') OR ( (CHARINDEX(',177,', p.categories)>0 OR p.categories='177') OR (CHARINDEX(',184,', p.categories)>0 OR p.categories='184') OR (CHARINDEX(',185,', p.categories)>0 OR p.categories='185') OR (CHARINDEX(',492,', p.categories)>0 OR p.categories='492') OR (CHARINDEX(',498,', p.categories)>0 OR p.categories='498') OR (CHARINDEX(',900,', p.categories)>0 OR p.categories='900')) | Timer 0: 1 ms | Timer 1: 81 ms | Timer 2: 6 ms | pagerTotal=53 | filtering=False | Timer 3: 1703 ms | catID=171 | kz.count=6 | 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(2437,2752,3525,3603,3610,5879,6085,6779,7789,8359,8769,8927,8987,8988,11180,11316,11365,11371,11920,12066,12067,12068,12069,12576,12586,12587,12588,12589,12590,12591,12592,12593,12594,12595,12596,12601,12602,12603,12610,12611,12612,12613,12614,12615,12621,12805,14904,14905,15043,16144,16145,16255,16261)) AS Sub WHERE Sub.RowIndex >= 1 AND Sub.RowIndex <= 12;

,177,184,185,492,498,900