SELECT DISTINCT p.id,p.[markaID],p.[retail_store_price],p.[Categories] FROM [products] AS p WHERE (CHARINDEX(',220,', p.categories)>0 OR p.categories='220') OR ( (CHARINDEX(',221,', p.categories)>0 OR p.categories='221') OR (CHARINDEX(',222,', p.categories)>0 OR p.categories='222') OR (CHARINDEX(',244,', p.categories)>0 OR p.categories='244') OR (CHARINDEX(',246,', p.categories)>0 OR p.categories='246') OR (CHARINDEX(',247,', p.categories)>0 OR p.categories='247') OR (CHARINDEX(',255,', p.categories)>0 OR p.categories='255') OR (CHARINDEX(',257,', p.categories)>0 OR p.categories='257') OR (CHARINDEX(',262,', p.categories)>0 OR p.categories='262') OR (CHARINDEX(',267,', p.categories)>0 OR p.categories='267') OR (CHARINDEX(',273,', p.categories)>0 OR p.categories='273') OR (CHARINDEX(',274,', p.categories)>0 OR p.categories='274') OR (CHARINDEX(',285,', p.categories)>0 OR p.categories='285') OR (CHARINDEX(',306,', p.categories)>0 OR p.categories='306') OR (CHARINDEX(',311,', p.categories)>0 OR p.categories='311') OR (CHARINDEX(',312,', p.categories)>0 OR p.categories='312') OR (CHARINDEX(',472,', p.categories)>0 OR p.categories='472') OR (CHARINDEX(',475,', p.categories)>0 OR p.categories='475') OR (CHARINDEX(',853,', p.categories)>0 OR p.categories='853') OR (CHARINDEX(',854,', p.categories)>0 OR p.categories='854') OR (CHARINDEX(',860,', p.categories)>0 OR p.categories='860') OR (CHARINDEX(',881,', p.categories)>0 OR p.categories='881') OR (CHARINDEX(',882,', p.categories)>0 OR p.categories='882') OR (CHARINDEX(',885,', p.categories)>0 OR p.categories='885') OR (CHARINDEX(',886,', p.categories)>0 OR p.categories='886') OR (CHARINDEX(',899,', p.categories)>0 OR p.categories='899') OR (CHARINDEX(',1061,', p.categories)>0 OR p.categories='1061') OR (CHARINDEX(',225,', p.categories)>0 OR p.categories='225') OR (CHARINDEX(',279,', p.categories)>0 OR p.categories='279') OR (CHARINDEX(',888,', p.categories)>0 OR p.categories='888') OR (CHARINDEX(',892,', p.categories)>0 OR p.categories='892') OR (CHARINDEX(',871,', p.categories)>0 OR p.categories='871') OR (CHARINDEX(',872,', p.categories)>0 OR p.categories='872') OR (CHARINDEX(',873,', p.categories)>0 OR p.categories='873') OR (CHARINDEX(',874,', p.categories)>0 OR p.categories='874') OR (CHARINDEX(',893,', p.categories)>0 OR p.categories='893') 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') OR (CHARINDEX(',868,', p.categories)>0 OR p.categories='868') OR (CHARINDEX(',869,', p.categories)>0 OR p.categories='869') OR (CHARINDEX(',870,', p.categories)>0 OR p.categories='870')) | Timer 0: 2 ms | Timer 1: 391 ms | Timer 2: 28 ms | pagerTotal=367 | filtering=False | Timer 3: 2693 ms | catID=220 | kz.count=26 | title DESC | title | Timer 4: 98 ms | 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,2132,2133,2143,2162,2164,2296,2346,2637,2639,2645,2672,2682,2775,2784,2797,2798,2801,2811,2816,2824,2825,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,4442,4768,4951,5027,5075,5104,5464,5466,5540,5812,5819,5824,5849,5853,5856,5865,5867,5868,5954,6125,6126,6294,6317,6434,6438,6650,6690,6726,7246,7248,7265,7266,7268,7391,7416,7427,7428,7475,7523,7572,7696,7697,7730,7783,7794,7835,8067,8069,8256,8261,8263,8265,8266,8268,8369,8611,8770,8810,8811,8832,8833,8874,8904,8910,8939,8943,8944,8945,8953,8969,8983,9107,9111,11397,11408,11409,11425,11451,11453,11477,11536,11538,11539,11540,11547,11551,11552,11558,11560,11563,11574,11575,11577,11580,11585,11586,11691,11841,11842,11898,11938,11941,11997,12039,12046,12048,12051,12129,12141,12155,12156,12157,12163,12168,12199,12227,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,13876,13881,14903,14912,14913,14914,14915,14917,14918,14919,14920,14921,14922,14923,14924,14926,14928,14931,14933,14934,14935,14936,14937,14938,14939,14940,14941,14942,14943,14956,15024,15025,15027,15028,15061,15070,15080,15090,15091,15092,15127,15128,16138,16139,16197,16211,16217,16225,16228,16234,16238,16239,16241,16242,16243,16244,16245,16246,16247,16262,16269,16279,16297,16298,16301,16302,16303,16305,16329,16346,16473,16476,16477,16478,16510,16511,16513,16554,16555,16556,16557,16558,16559,16560,16561,16563,16578,16589,16592,16594,16597,16598,16612,16624,16678,16769,16781,16782,16783,16784,16788,16789,16820,16821,16825,16826,16848,16876,16904,18992,18993)) 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