<--SELECT urun_ozellik_degerleri.sema_ozellik_id, urun_ozellik_degerleri.ozellik_adi, urun_ozellik_degerleri.degeri, urun_ozellik_degerleri.deger_id, COUNT(DISTINCT ur.id) AS adet FROM urun_ozellik_degerleri JOIN urunler ur ON ur.id = urun_ozellik_degerleri.urun_id and ur.id in (22562,24059,30027,34712,34642,34610,33969,33736,33602,33601,33600,33541,33231,32489,30026,29950,29908,32067,32064,30206,35249,34740,50247,48917,29948,29933,33229,31973,33796,34118,35500,33221,33219,29903,33235,34116,30228,33821,35508,29905,33236,33223,33230,50305,50437,49448,49456,48227,47245,48283,48228,49232,45251,45915,50420,50642,50954,50787,50786,77137,73189,73188,50941,49234,49458,35248,49041,49237,50982,49310,49309,77139,77944,34117,33227,28131,50752,50753,50754,50751,49447,79060,78834,78494,79200,79366,79368,79364,79552,79865,80082,80306,80307,80308,80309,46736,50953,81637,81805,81873,81806,79752,78489,81660,81999,82371,82370,79658,78341,82512,82401,147862,82466,147859,82471,147861,147913,147965,147964,147912,147962,82470,82469,82468,148155,148317,148434,148427,80445,148388,148432,148362,148364,148435,148439,148428,148241,82400,148720,148433,148734,148727,148731,148730,148729,148728,148733,150306,150818,150889,150596,151483,151519,150906,152140,151928,150424,150422,152894,150425,153089,153105,153137,153138,151765,153321,153354,153254,153403,153360,153365,153028,153027,153447,153760,153806,153962,153960,154199,154198,154696,154746,154949,154950,154748,155336,154337,155365,155403,155460,154916,154697,155551,155735,155907,155919,155808,157451,156069,154749,158084,158087,158085,156934,157065,156031,158120,158270,158275,158118,158412,158271,154795,149507,46559,154253,50499,45976,77878,48359,77895,154952,154953,155166,150307,149859,158086,79553,50981,79932,154463,148723,153992,154685,156849,153332,152567,155572,49040,79271,153993,153994,153492,155165,152729,155157,148257,148652,150763,82135,156068,156500,150888,153049,150298,155156,150887,155158,153991,154989,159628,160239,160459,157064,159201,160606,160604,160601,160489,160309,160208,160153,159407,159069,158925,158877,155285,158589,158802,160241,160030,159108,159107,159106,158183,158182,158181,159716,157708,160661,157535,159105,158083,158082,158077,158076,158124,158119,159367,160452,160451,160441,160439,160010,160006,159972,158821,158054,157741,157063,156380,160887,160252,160238,160026,160662,160207,158116,158117,160031,161180,161366,161260,161221,161652,161628,161659,161133,160240,161924,161925,161926,161927,156440,162057,162242,162237,162233,162090,157707,162852,162280,162089,160886,160885,160012,160432,162086,163025,158825,162695,162891,163472,163473,163666,163563,163555,163963,164206,164278,164514,164359,164616,161984,164665,164615,164848,164850,165019,165382,162225,164288,165746,165747,165883,165812,166100,166101,166182,166183,166184,166189,165859,166121,165521,166441,166497,166498,166490,166444,166555,166556,157710,166437,166883,166415,164854,164852,164851,164819,164656,164052,166427,166426,164314,166428,164658,164273,167794,168303,168237,167967,167889,167888,167853,167738,167736,167734,167730,167729,167726,167724,167722,167721,167720,167714,166889,166888,166887,166886,166885,166884,166882,166881,166874,166430,166429,166424,165957,165519,165449,165444,165428,165422,165365,165348,164914,164913,164853,164820,164655,164653,164281,164264,163067,161530,160155,166867,166890,165508,165504,164821,164650,166891,166901,168317,168268,158826,158828,159278,160866,161063,161064,162091,162093,162382,162520,162881,163208,163308,164040,164118,164123,164124,164324,164339,164344,164346,164406,164417,164512,164513,164515,164516,164609,164610,164664,164668,164675,164793,165807,165854,165857,166119,166155,162125,163420,162521,168461,168375,168783,168906,165956,165955,165518,165424,165421,165420,165143,165144,165191,165192,165193,165209,165210,165211,165212,165213,165214,167716,167718,168126,168121,166846,165447,169226,169283,169408,165433,164583,169409,169692,165520,169868,170014,170075,166869,170077,170096,170100,170086,170349,170351,170352,162183,170401,170466,170399,170398,170744,170803,170836,170837,168495,171597,171599,171604,168403,171706,171652,171651,171730,171655,171946,172001,172011,172012,172120,172144,172145,172146,172147,172223,172224,172207,172506,172572,172442,172440,172441,172658,170084,172542,172780,170105,173000,171663,171669,172865,173091,173092,173102,173142,173174,173219,172867,172868,172864,172271,164620,165195,172270,172274,172272,172275,172541,173599,173567,170755,170388,173340,173350,173346,171678,173643,171681,173879,171664,173343,173647,173648,173649,174230,174305,174330,174294,174295,174310,174274,174059,174060,172273,172276,174308,173650,174514,174199,174616,174195,174196,173372,173561,174056,174077,173377,174076,174058,174057,173351,173373,173210,173375,173379,173374,174079,174080,174055,173565,174329,174300,171934,168921,175130,170094,175235,175457,175458,175551,175612,175770,175856,175860,174512,174614,175991,175992,173560,175933,176189,176246,176029,176305,175594,176583,176752,171660,176828,176829,174193,176818,176901,173559,176912,172268,172863,176819,171661,176675,176812,176989,174275,176683,177146,177357,177365,176987,177509,177510,177514,177516,176990,177417,177568,177576,173363,177603,165427,160607,174293,177542,173275,176821,177793,177880,177881,176820,175510,177543,172293,172439,174066,176813,178161,177174,178201,174082,178356,178481,175580,178382,178600,178607,178696,176034,173362,171682,178975,178976,176550,179196,179407,179595,174788,178523,178454,178453,179818,179938,179386,179400,179301,180047,180048,180049,179921,180117,180118,179657,180194,174297,180552,180676,180677,180017,180018,180019,180836,180837,179853,180673,180526,180674,180856,180857,180858,180876,180028,180899,180903,180941,180961,179672,179850,180139,180033,179852,179671,179849,181004,180663,175679,180984,179848,180983,179857,179842,179673,179837,179675,179839,179838,181163,179670,179669,180138,179674,180032,181377,181378,181396,181068,181221,181072,181071,181070,181222,180539,181069,181468,181586,180135,180536,181445,180911,181444,181066,181693,181302,181300,181303,181308,181301,180534,181804,177024,182044,181745,182090,182092,182156,181223,182091,180662,180537,179300,181290,180016,179457,179920,180535,181299,181065,182589,182610,182587,183121,176564,183345,183774,183094,183179,183344,184072,181304,183346,184238,183666,183653,183610,183649,183606,184363,183665,184370,183652,184564,184725,184788,184716,184722,184724,184723,184726,182515,184979,183663,185040,185042,185057,184718,185161,185162,185163,179484,183797,185693,185702,182853,185714,183802,184407,174734,182490,186124,175569,186382,181443,179891,184294,186892,187111,187112,187203,187249) AND ur.satis_durumu=1 AND ur.marka_id in (5,16,821,194) AND (ur.bayi_id='0' or ur.bayi_id='3634') JOIN urun_kategorileri uk ON ur.id = uk.urun_id and uk.kategori_id = 1810 where urun_ozellik_degerleri.tur = 2 and urun_ozellik_degerleri.ozellik_durum = 1 and urun_ozellik_degerleri.deger_durum = 1 GROUP BY urun_ozellik_degerleri.deger_id ORDER BY urun_ozellik_degerleri.ozellik_sira ASC , urun_ozellik_degerleri.deger_sira ASC;-->