SELECT DISTINCT p.id,p.[markaID],p.[retail_store_price],p.[Categories] FROM [products] AS p WHERE (CHARINDEX(',220,', p.categories)>0) OR ( (CHARINDEX(',221,', p.categories)>0) OR (CHARINDEX(',222,', p.categories)>0) OR (CHARINDEX(',244,', p.categories)>0) OR (CHARINDEX(',246,', p.categories)>0) OR (CHARINDEX(',247,', p.categories)>0) OR (CHARINDEX(',255,', p.categories)>0) OR (CHARINDEX(',257,', p.categories)>0) OR (CHARINDEX(',262,', p.categories)>0) OR (CHARINDEX(',267,', p.categories)>0) OR (CHARINDEX(',273,', p.categories)>0) OR (CHARINDEX(',274,', p.categories)>0) OR (CHARINDEX(',285,', p.categories)>0) OR (CHARINDEX(',306,', p.categories)>0) OR (CHARINDEX(',311,', p.categories)>0) OR (CHARINDEX(',312,', p.categories)>0) OR (CHARINDEX(',472,', p.categories)>0) OR (CHARINDEX(',475,', p.categories)>0) OR (CHARINDEX(',853,', p.categories)>0) OR (CHARINDEX(',854,', p.categories)>0) OR (CHARINDEX(',860,', p.categories)>0) OR (CHARINDEX(',881,', p.categories)>0) OR (CHARINDEX(',882,', p.categories)>0) OR (CHARINDEX(',885,', p.categories)>0) OR (CHARINDEX(',886,', p.categories)>0) OR (CHARINDEX(',899,', p.categories)>0) OR (CHARINDEX(',1061,', p.categories)>0) OR (CHARINDEX(',225,', p.categories)>0) OR (CHARINDEX(',279,', p.categories)>0) OR (CHARINDEX(',888,', p.categories)>0) OR (CHARINDEX(',892,', p.categories)>0) OR (CHARINDEX(',871,', p.categories)>0) OR (CHARINDEX(',872,', p.categories)>0) OR (CHARINDEX(',873,', p.categories)>0) OR (CHARINDEX(',874,', p.categories)>0) OR (CHARINDEX(',893,', p.categories)>0) OR (CHARINDEX(',331,', p.categories)>0) OR (CHARINDEX(',865,', p.categories)>0) OR (CHARINDEX(',866,', p.categories)>0) OR (CHARINDEX(',867,', p.categories)>0) OR (CHARINDEX(',890,', p.categories)>0) OR (CHARINDEX(',895,', p.categories)>0) OR (CHARINDEX(',868,', p.categories)>0) OR (CHARINDEX(',869,', p.categories)>0) OR (CHARINDEX(',870,', p.categories)>0)) | pagerTotal=341 | filtering=False | catID=220 | kz.count=26 | 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(2124,2129,2131,2132,2133,2143,2145,2149,2162,2164,2296,2346,2637,2639,2672,2676,2682,2775,2797,2798,2801,2808,2810,2811,2816,2824,2825,2832,2842,2843,2847,2848,3090,3202,3289,3392,3421,3423,3432,3473,3483,3485,3508,3509,3512,3613,3615,3639,3648,3685,3686,3692,3693,4383,4442,4768,4951,5027,5075,5104,5464,5466,5540,5812,5819,5824,5849,5853,5856,5865,5867,5868,5954,6125,6126,6294,6434,6438,6650,6690,6726,7246,7248,7265,7266,7268,7391,7416,7427,7428,7475,7523,7572,7696,7697,7730,7783,7794,7835,7996,8067,8069,8256,8261,8263,8265,8266,8268,8369,8611,8705,8770,8810,8832,8833,8874,8904,8910,8939,8943,8944,8945,8969,8983,9107,9111,11397,11408,11409,11425,11451,11453,11477,11536,11538,11539,11540,11551,11552,11558,11560,11563,11574,11575,11577,11580,11585,11691,11841,11842,11898,11938,11941,11944,11997,12039,12046,12047,12048,12051,12129,12141,12155,12156,12157,12158,12168,12199,12227,12281,12282,12302,12303,12548,12551,12552,12553,12554,12555,12556,12557,12559,12560,12561,12562,12565,12622,12623,12625,12626,12628,12629,12630,12631,12632,12633,12738,12739,12740,12741,12742,12743,12744,12745,12746,12747,12748,12749,12750,12751,12752,12753,12754,12755,12756,12757,12758,12760,12761,12762,12763,12764,12765,12766,12767,12768,12770,12771,12772,12773,12774,12775,12776,12777,12778,12779,12780,12781,12782,12783,12784,12785,12786,12787,12788,12789,12790,12791,12792,12793,12795,12796,12797,12799,12800,12801,12802,12803,12824,12825,12827,13854,13869,13874,13875,13876,13881,14903,14912,14913,14914,14915,14917,14918,14919,14920,14921,14922,14923,14924,14928,14931,14933,14934,14935,14936,14937,14938,14939,14940,14941,14942,14943,14956,15024,15025,15027,15028,15061,15080,15090,15091,15092,15127,15128,16138,16197,16211,16217,16225,16228,16234,16238,16239,16240,16241,16242,16243,16244,16245,16246,16247,16262,16269,16274,16279,16297,16298,16301,16302,16303,16305,16329,16346,16477,16513,16589,16592,16594,16597,16598)) AS Sub WHERE Sub.RowIndex >= 1 AND Sub.RowIndex <= 12;

,221,222,244,246,247,255,257,262,267,273,274,285,306,311,312,472,475,853,854,860,881,882,885,886,899,1061,225,279,888,892,871,872,873,874,893,331,865,866,867,890,895,868,869,870