SELECT DISTINCT p.id,p.[markaID],p.[retail_store_price],p.[Categories] FROM [products] AS p WHERE (CHARINDEX(',437,', p.categories)>0) OR ( (CHARINDEX(',858,', p.categories)>0) OR (CHARINDEX(',887,', p.categories)>0) OR (CHARINDEX(',927,', p.categories)>0) OR (CHARINDEX(',929,', p.categories)>0) OR (CHARINDEX(',957,', p.categories)>0) OR (CHARINDEX(',959,', p.categories)>0) OR (CHARINDEX(',960,', p.categories)>0) OR (CHARINDEX(',962,', p.categories)>0) OR (CHARINDEX(',971,', p.categories)>0) OR (CHARINDEX(',1014,', p.categories)>0) OR (CHARINDEX(',1016,', p.categories)>0) OR (CHARINDEX(',1017,', p.categories)>0) OR (CHARINDEX(',1019,', p.categories)>0) OR (CHARINDEX(',1045,', p.categories)>0)) | pagerTotal=126 | filtering=False | catID=437 | kz.count=14 | title DESC | title | 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,6318,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,8981,9031,11198,11200,11202,11383,11407,11456,11535,11567,11688,11847,11912,11998,11999,12000,12001,12032,12044,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,16601)) AS Sub WHERE Sub.RowIndex >= 1 AND Sub.RowIndex <= 12;

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