SELECT DISTINCT p.id,p.[markaID],p.[retail_store_price],p.[Categories] FROM [products] AS p WHERE (CHARINDEX(',30,', p.categories)>0) OR ( (CHARINDEX(',70,', p.categories)>0) OR (CHARINDEX(',71,', p.categories)>0) OR (CHARINDEX(',72,', p.categories)>0) OR (CHARINDEX(',73,', p.categories)>0) OR (CHARINDEX(',945,', p.categories)>0)) | pagerTotal=96 | filtering=False | catID=30 | kz.count=5 | 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(5226,5241,5256,5257,5631,5702,5703,5789,6011,6102,6597,6826,6927,6963,7594,7657,7707,7762,7880,8465,8474,8478,8479,9046,10148,10150,12271,12356,12357,12358,12359,12360,12361,12362,12363,12364,12365,12366,12367,12368,12369,12370,12371,12372,12373,12374,12375,12376,12382,12492,12534,12535,12536,12537,15109,15110,15111,15114,15115,15116,15117,15119,15120,15121,15122,15123,16193,16194,16195,16196,16199,16200,16201,16202,16212,16231,16336,16387,16388,16392,16393,16394,16404,16445,16446,16452,16454,16455,16456,16460,16662,16663,16676,16677,16689,16704)) AS Sub WHERE Sub.RowIndex >= 1 AND Sub.RowIndex <= 12;

,70,71,72,73,945