SELECT DISTINCT p.id,p.[markaID],p.[retail_store_price],p.[Categories] FROM [products] AS p WHERE (CHARINDEX(',30,', p.categories)>0 OR p.categories='30') OR ( (CHARINDEX(',70,', p.categories)>0 OR p.categories='70') OR (CHARINDEX(',71,', p.categories)>0 OR p.categories='71') OR (CHARINDEX(',72,', p.categories)>0 OR p.categories='72') OR (CHARINDEX(',73,', p.categories)>0 OR p.categories='73') OR (CHARINDEX(',945,', p.categories)>0 OR p.categories='945') OR (CHARINDEX(',1069,', p.categories)>0 OR p.categories='1069') OR (CHARINDEX(',1070,', p.categories)>0 OR p.categories='1070')) | pagerTotal=96 | filtering=False | catID=30 | kz.count=7 | 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,7707,7762,7880,8465,8474,8478,8479,9046,10148,10150,12356,12357,12358,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,15121,15122,15123,16193,16194,16195,16196,16199,16200,16201,16202,16212,16231,16336,16387,16388,16392,16393,16394,16404,16445,16446,16452,16453,16454,16455,16456,16460,16662,16663,16676,16677,16689,16704,16757,16758,16764)) AS Sub WHERE Sub.RowIndex >= 1 AND Sub.RowIndex <= 12;

,70,71,72,73,945,1069,1070