SELECT DISTINCT p.id,p.[markaID],p.[retail_store_price],p.[Categories] FROM [products] AS p WHERE (CHARINDEX(',34,', p.categories)>0 OR p.categories='34') OR ( (CHARINDEX(',86,', p.categories)>0 OR p.categories='86') OR (CHARINDEX(',101,', p.categories)>0 OR p.categories='101') OR (CHARINDEX(',104,', p.categories)>0 OR p.categories='104') OR (CHARINDEX(',105,', p.categories)>0 OR p.categories='105') OR (CHARINDEX(',944,', p.categories)>0 OR p.categories='944')) | pagerTotal=56 | filtering=False | catID=34 | 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(2079,4799,5054,6211,7867,8513,8654,11670,11848,11862,12549,12550,12563,12564,12566,12567,12568,12569,12619,12634,12635,12636,12637,12638,12639,12640,12641,12642,12643,12644,12645,12650,12651,12652,12653,12654,12655,12656,13882,13885,15078,16129,16130,16131,16132,16133,16399,16401,16402,16531,16724,16725,16726,16727,16816,16818)) AS Sub WHERE Sub.RowIndex >= 1 AND Sub.RowIndex <= 12;

,86,101,104,105,944