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')) | Timer 0: 1 ms | Timer 1: 94 ms | Timer 2: 2 ms | pagerTotal=103 | filtering=False | Timer 3: 622 ms | catID=30 | kz.count=7 | title DESC | title | Timer 4: 35 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(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,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,16938,17951,18962,18963,18964,18995,18996,19000)) AS Sub WHERE Sub.RowIndex >= 1 AND Sub.RowIndex <= 12;

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