SELECT DISTINCT p.id,p.[markaID],p.[retail_store_price],p.[Categories] FROM [products] AS p WHERE (CHARINDEX(',6,', p.categories)>0 OR p.categories='6') OR ( (CHARINDEX(',58,', p.categories)>0 OR p.categories='58') OR (CHARINDEX(',65,', p.categories)>0 OR p.categories='65') OR (CHARINDEX(',69,', p.categories)>0 OR p.categories='69') OR (CHARINDEX(',85,', p.categories)>0 OR p.categories='85') OR (CHARINDEX(',102,', p.categories)>0 OR p.categories='102') OR (CHARINDEX(',109,', p.categories)>0 OR p.categories='109') OR (CHARINDEX(',110,', p.categories)>0 OR p.categories='110') OR (CHARINDEX(',111,', p.categories)>0 OR p.categories='111') OR (CHARINDEX(',933,', p.categories)>0 OR p.categories='933') OR (CHARINDEX(',937,', p.categories)>0 OR p.categories='937') OR (CHARINDEX(',938,', p.categories)>0 OR p.categories='938') OR (CHARINDEX(',942,', p.categories)>0 OR p.categories='942') OR (CHARINDEX(',943,', p.categories)>0 OR p.categories='943') OR (CHARINDEX(',952,', p.categories)>0 OR p.categories='952') OR (CHARINDEX(',964,', p.categories)>0 OR p.categories='964') OR (CHARINDEX(',1065,', p.categories)>0 OR p.categories='1065')) | pagerTotal=77 | filtering=False | catID=6 | kz.count=16 | 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,2434,2686,2687,2760,3780,4816,5840,6212,6256,6585,6820,6838,6839,6905,7415,8027,8075,8117,8118,8213,8297,8661,8668,8669,8989,8991,11274,11307,11308,11583,11863,12124,12224,12234,12398,12399,12496,12498,12499,12647,12648,12649,12657,13886,13887,13888,13889,13894,14989,14999,15087,15108,16173,16174,16281,16282,16287,16381,16382,16430,16493,16494,16553,16654,16657,16659,16694,16698,16699,16701,16710,16720)) 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,1065