SELECT DISTINCT p.id,p.[markaID],p.[retail_store_price],p.[Categories] FROM [products] AS p WHERE (CHARINDEX(',306,', p.categories)>0 OR p.categories='306') OR ( (CHARINDEX(',331,', p.categories)>0 OR p.categories='331') OR (CHARINDEX(',865,', p.categories)>0 OR p.categories='865') OR (CHARINDEX(',866,', p.categories)>0 OR p.categories='866') OR (CHARINDEX(',867,', p.categories)>0 OR p.categories='867') OR (CHARINDEX(',890,', p.categories)>0 OR p.categories='890') OR (CHARINDEX(',895,', p.categories)>0 OR p.categories='895')) | pagerTotal=63 | filtering=False | catID=306 | kz.count=6 | 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(2164,2775,2797,2798,2801,2810,2811,2816,2824,2825,5812,5856,6294,6726,7996,8832,8833,8874,8910,9107,11425,11585,11841,11842,11997,12046,12047,12048,12199,12302,12783,12784,12785,12786,12787,12788,12789,12800,12801,14912,14913,14914,14915,14928,14933,14934,14935,14936,14937,14938,15024,16238,16239,16240,16247,16279,16303,16305,16473,16597,16612,16624,16784)) AS Sub WHERE Sub.RowIndex >= 1 AND Sub.RowIndex <= 12;

,331,865,866,867,890,895