SELECT DISTINCT p.id,p.[markaID],p.[retail_store_price],p.[Categories] FROM [products] AS p WHERE (CHARINDEX(',13,', p.categories)>0 OR p.categories='13') OR ( (CHARINDEX(',126,', p.categories)>0 OR p.categories='126') OR (CHARINDEX(',140,', p.categories)>0 OR p.categories='140') OR (CHARINDEX(',1068,', p.categories)>0 OR p.categories='1068')) | pagerTotal=95 | filtering=False | catID=13 | kz.count=3 | 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(3841,3915,3917,3923,3925,3950,3996,3997,3999,4000,4016,4018,4020,4078,5008,5262,5290,5311,5312,5542,6710,7769,7907,8633,8634,8635,11882,12262,12401,12402,12407,12408,12409,12410,12411,12413,12414,12415,12416,12417,12418,12419,12420,12421,12422,12423,12424,12425,12426,12427,12428,12429,12430,12431,12432,12433,12434,12435,12436,12437,12438,12440,12441,12442,12443,12444,12445,12446,12448,12451,12452,12531,12532,12533,12618,12730,15055,15058,15126,16182,16213,16214,16441,16461,16462,16463,16464,16485,16492,16522,16523,16711,16743,16753,16804)) AS Sub WHERE Sub.RowIndex >= 1 AND Sub.RowIndex <= 12;

,126,140,1068