SELECT DISTINCT p.id,p.[markaID],p.[retail_store_price],p.[Categories] FROM [products] AS p WHERE (CHARINDEX(',6,', p.categories)>0) OR ( (CHARINDEX(',58,', p.categories)>0) OR (CHARINDEX(',65,', p.categories)>0) OR (CHARINDEX(',69,', p.categories)>0) OR (CHARINDEX(',85,', p.categories)>0) OR (CHARINDEX(',102,', p.categories)>0) OR (CHARINDEX(',109,', p.categories)>0) OR (CHARINDEX(',110,', p.categories)>0) OR (CHARINDEX(',111,', p.categories)>0) OR (CHARINDEX(',933,', p.categories)>0) OR (CHARINDEX(',937,', p.categories)>0) OR (CHARINDEX(',938,', p.categories)>0) OR (CHARINDEX(',942,', p.categories)>0) OR (CHARINDEX(',943,', p.categories)>0) OR (CHARINDEX(',952,', p.categories)>0) OR (CHARINDEX(',964,', p.categories)>0)) | pagerTotal=76 | filtering=False | catID=6 | kz.count=15 | 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(2172,2174,2175,2238,2360,2433,2434,2686,2687,2760,3780,4816,5840,6212,6256,6585,6820,6838,6839,6905,7415,8027,8075,8117,8118,8213,8297,8630,8661,8668,8669,8989,8991,11274,11307,11308,11583,11863,12124,12224,12234,12393,12395,12396,12398,12399,12496,12498,12499,12647,12648,12649,12657,13886,13887,13888,13889,13894,14989,14999,15087,15108,15118,16174,16281,16282,16287,16381,16382,16430,16493,16528,16553,16654,16657,16659)) AS Sub WHERE Sub.RowIndex >= 1 AND Sub.RowIndex <= 12;

,58,65,69,85,102,109,110,111,933,937,938,942,943,952,964