SELECT DISTINCT p.id,p.[markaID],p.[retail_store_price],p.[Categories] FROM [products] AS p WHERE (CHARINDEX(',437,', p.categories)>0 OR p.categories='437') OR ( (CHARINDEX(',858,', p.categories)>0 OR p.categories='858') OR (CHARINDEX(',887,', p.categories)>0 OR p.categories='887') OR (CHARINDEX(',927,', p.categories)>0 OR p.categories='927') OR (CHARINDEX(',929,', p.categories)>0 OR p.categories='929') OR (CHARINDEX(',957,', p.categories)>0 OR p.categories='957') OR (CHARINDEX(',959,', p.categories)>0 OR p.categories='959') OR (CHARINDEX(',960,', p.categories)>0 OR p.categories='960') OR (CHARINDEX(',962,', p.categories)>0 OR p.categories='962') OR (CHARINDEX(',971,', p.categories)>0 OR p.categories='971') OR (CHARINDEX(',1014,', p.categories)>0 OR p.categories='1014') OR (CHARINDEX(',1016,', p.categories)>0 OR p.categories='1016') OR (CHARINDEX(',1017,', p.categories)>0 OR p.categories='1017') OR (CHARINDEX(',1019,', p.categories)>0 OR p.categories='1019') OR (CHARINDEX(',1045,', p.categories)>0 OR p.categories='1045') OR (CHARINDEX(',1067,', p.categories)>0 OR p.categories='1067')) | Timer 0: 1 ms | Timer 1: 147 ms | Timer 2: 1 ms | pagerTotal=136 | filtering=False | Timer 3: 1054 ms | catID=437 | kz.count=15 | title DESC | title | Timer 4: 28 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(2168,3183,3184,3185,3189,3653,3703,3710,4166,4924,5397,5398,5571,5651,6110,6112,6389,6559,6560,6694,6725,6836,7126,7127,7128,7129,7413,7496,7776,7778,7780,7914,8259,8275,8288,8289,8293,8295,8374,8650,8651,8711,8744,8745,8866,8869,8871,8959,8976,8981,9031,11197,11198,11200,11202,11383,11407,11439,11456,11535,11567,11688,11847,11912,11998,11999,12000,12001,12032,12044,12045,12118,12182,12183,12184,12185,12186,12187,12216,12235,12242,13864,13865,13866,13867,13868,13870,13871,13872,13873,13877,14896,14947,14949,14950,14951,14952,14965,15000,15009,15011,15012,15013,15014,15017,15018,15019,15020,15021,15096,16169,16226,16227,16296,16306,16307,16308,16309,16310,16311,16312,16313,16315,16323,16325,16337,16412,16416,16458,16593,16601,16709,16736,16737,16738,16777)) AS Sub WHERE Sub.RowIndex >= 1 AND Sub.RowIndex <= 12;

,858,887,927,929,957,959,960,962,971,1014,1016,1017,1019,1045,1067