<--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 (20980,22563,22562,22557,22744,23491,23608,23609,23610,23611,23844,23860,23861,24059,24314,24319,30027,30611,30612,30616,31135,33187,34961,34712,34709,34643,34642,34610,34096,33736,33714,33233,33232,33231,33222,33179,33176,33175,33051,32489,32066,31793,31068,30026,29950,31549,29908,29906,34755,34741,32067,32065,32064,30206,35249,34740,35458,34768,32158,48357,50247,48918,48917,48356,48349,32694,29943,48393,34748,34747,30826,30003,29948,30023,35033,29907,30388,29933,29912,33668,33229,29914,35160,29904,31973,31446,33228,33796,34118,29925,30384,35500,33220,29922,33221,32812,33219,29903,33235,48345,48344,49421,49408,48350,34116,35162,29916,47631,34251,30228,29917,33821,35508,29905,33236,33223,33226,33225,29930,33230,35298,31790,31792,33234,31979,48346,49457,49461,49453,49460,47088,49224,49223,48225,50437,49459,49448,49456,48227,49231,47481,47245,48283,48228,48420,49232,47030,46009,45251,45268,45858,45915,48913,50420,50487,34954,50402,50401,50532,50642,50625,50759,49538,50954,50785,50955,51091,51090,50926,50787,50786,77136,77137,77252,73218,73189,73188,77122,49450,50941,49234,49458,77619,35247,35248,73220,50950,50646,49041,49237,49235,50982,49233,49310,49552,48352,49545,49534,49309,49302,77139,50245,49238,48353,48351,77944,34713,34710,34117,33227,33224,77903,77620,50936,78159,49447,78156,49670,78289,78075,78383,73217,78380,78381,78382,50246,48327,78625,77602,78158,78285,78291,79060,78834,78831,78830,78495,78494,79200,78835,78288,79366,79368,79365,79364,79551,79552,79414,79656,79657,79865,46061,80044,80082,80213,80212,80641,80640,80079,81004,81091,50953,81341,81006,81589,81637,81805,81873,81872,81806,79752,81765,79659,81342,81660,82001,80450,82000,81999,81005,82373,82371,80446,82372,82370,79658,78341,82407,82403,82512,82405,82404,82401,147862,82466,147859,147858,82471,147861,147860,147965,147964,147912,147961,147962,82467,82470,82469,82468,148173,148154,148155,148221,148222,148276,81592,148441,148318,148317,148431,148434,148430,148429,148427,148386,80445,148388,148432,148362,148364,148435,148439,148581,148363,148428,148241,148628,148627,82400,148724,148720,148726,148433,148734,148722,148727,148725,148721,148731,148735,148732,148730,148729,148728,148736,148733,148756,149230,149291,149345,149648,150046,150306,150378,150499,150760,147963,150856,150818,150889,150596,151035,82406,150595,151344,151483,151484,150905,151519,150906,150907,151929,152039,152140,151928,150658,150757,150424,150422,152222,152711,152739,152618,152027,80444,150425,153056,153089,153137,153138,151765,153257,153321,153354,153254,153402,153403,153365,153029,153028,153027,153536,153635,153692,153728,153722,153737,153760,153806,153896,153962,153960,153961,154099,154199,154198,154392,154521,154589,154359,154696,154796,154797,154914,154913,154912,155073,155187,155202,155336,155317,154337,155365,155380,155403,155460,154916,154697,155506,155548,155551,155735,153920,155808,156426,156834,155550,157451,157533,156462,156427,158084,158087,158085,156934,157065,157135,158120,158270,156938,159045,158412,158271,154795,150904,150598,150408,149507,149872,50970,51105,148447,149369,77873,46559,151556,153480,152731,153455,148446,50499,45976,77878,48359,49236,46609,77895,50790,49449,148445,148387,148385,151048,152003,148436,148437,151796,152992,150307,149859,158086,150900,155728,79553,151531,50981,79932,153989,153139,157742,153177,154463,148723,153992,154242,154685,156849,153331,153456,153332,154898,153545,152567,155694,156319,153481,155572,156119,49040,79271,153426,50788,151347,153990,153281,150420,149963,153492,150886,152993,154235,33665,51104,150885,156120,155269,157341,152729,153441,151530,155157,153987,149589,151806,151795,152997,155541,153026,153958,153959,154314,157765,159699,159698,159697,150763,152370,150761,153482,156500,155699,150762,155158,153991,154989,153723,32439,32069,159628,156731,156935,160137,158019,160011,160449,160459,160458,157064,159201,160489,160414,160349,160208,159407,159284,158904,158589,159821,159716,158428,156794,160661,160660,159178,159976,156905,159105,158124,158119,160358,159367,160452,160451,160443,160442,160439,160435,160433,160016,160007,160006,160004,159387,158821,158054,157741,157063,156380,160252,160026,160662,160207,161180,161531,161659,161926,161927,156440,162230,162235,162090,160434,162852,162770,162358,162280,161751,161161,160886,160885,160450,160012,160432,160049,162086,160431,163025,158825,163472,163473,163572,164261,164267,157532,164514,164518,164359,159385,165019,164420,162225,165724,165746,165747,165584,165883,166100,166101,166182,166183,166184,166189,166156,165859,166121,164274,166497,166498,166499,166490,166444,166555,166556,166758,166437,167076,165376,166426,164314,164033,165858,168134,167794,168272,168273,167889,167888,167714,167671,167670,167669,167075,166882,166881,166874,166430,166429,165957,165506,165501,164272,164264,163067,162232,161823,161530,160155,166890,165508,165505,165504,156215,168445,158826,158828,159278,160866,161064,162091,162092,162382,162520,162790,163249,162882,163208,163308,163462,164034,164036,164037,164038,164039,164118,164122,164124,164139,163822,164324,164339,164342,164344,164346,164417,164510,164511,164512,164513,164515,164516,164517,164609,164610,164664,164668,164669,164672,164674,164675,164676,164793,164906,165807,165854,165856,165857,166119,166120,166155,166848,167533,167844,168461,168463,168464,168465,168466,168467,168536,168462,168599,168374,168375,168773,168774,168783,168905,168904,168922,168920,168906,165347,169283,169409,169868,170009,170349,170351,170352,170456,170466,170398,167923,170744,170803,170836,170837,170854,170455,165002,165001,171597,171599,171706,171946,172001,172011,172012,172120,172144,172145,172146,172147,172223,172224,172207,172572,172440,170084,172542,172780,172881,173000,170454,170453,173091,173092,173142,173143,173172,173321,173322,173325,172541,173385,173599,173370,173566,170653,173346,174616,174675,174774,173373,171826,171934,168921,171825,175210,175457,175458,175467,175551,175612,175770,173341,174614,174695,175991,175992,175933,176108,175945,175530,173677,176029,176305,175594,176752,176828,176829,176818,176912,176989,177314,177344,177358,177515,177558,177568,177576,160607,178161,178201,178362,178579,178587,178607,178689,176034,173368,173376,173362,173342,178975,179187,179196,179463,179536,179818,179938,180050,180054,180117,180118,180195,180196,180552,180676,180677,180836,180856,180857,180858,180859,180860,180861,180876,180899,180940,180961,181004,181163,181378,181468,181586,181593,181693,182044,182824,183774,183094,183179,184072,184238,184363,184370,184564,184852,184979,185042,185057,185095,185176,185209,185534,185535,185536,185547,185669,185702,183804,174734,182490,175569,186397,186401,175924,179891,184294,187110,187112,187203,187490) AND ur.satis_durumu=1 AND ur.marka_id in (5,256,75,1163) AND (ur.bayi_id='0' or ur.bayi_id='53060') 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;-->