<--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 (25481,25483,26096,27050,28808,25478,25004,29868,29846,29855,30039,30034,30061,30347,30650,30888,30890,31740,31767,32714,32751,31217,29949,31594,34572,32436,33586,30030,30029,30028,34226,29935,29872,30040,30448,34943,29945,30802,30449,32964,30769,30770,49106,49105,49103,45968,45812,48424,48423,50951,44949,50553,77735,77716,48958,46068,77726,77732,57535,77727,77186,77627,78497,78496,77715,48057,49512,49380,78426,78844,78845,77414,77718,79475,79367,57205,77945,79965,80046,49568,80803,80805,80810,81386,82516,82473,82142,147979,147899,148110,148103,148452,148514,148583,148820,149189,149205,151816,81648,149805,152021,148032,78472,82146,77722,82143,150343,148687,149647,81117,77719,78595,80826,34947,32962,34946,22433,33270,77724,78839,151236,150987,150240,152744,152747,152748,149023,44955,149656,152903,152902,152895,153035,150857,153118,153427,153726,154518,154836,155254,154583,154582,156309,156310,150332,150333,150423,148076,78234,158776,157877,157824,156030,155793,155498,150774,150568,150561,150398,82147,81116,79728,77723,30348,155611,159196,148818,159747,156923,155614,155708,155707,160890,161073,160889,161483,161783,161782,161780,161779,161777,159364,162202,155097,161295,161249,160218,160176,159368,159160,159033,156575,155206,153745,163070,163069,163068,162385,160894,158840,160892,160883,160572,159999,159971,159372,159198,159197,159154,158829,158742,158372,158284,157794,156914,156693,156671,156482,155552,155319,155318,154803,153537,153353,153333,153295,153034,152751,152750,152304,150082,82145,35850,154141,154140,154038,162694,162689,162688,162638,160600,158487,158486,150334,150277,82325,163548,150239,152828,152829,34422,163935,150238,164396,164397,162737,164577,157521,164798,164797,152363,160893,164905,164904,164903,164902,164988,165034,155013,165379,165380,165409,165498,165586,165543,165617,165714,165760,165785,165784,165783,165782,165791,165792,165793,152830,154341,152703,165831,165840,165900,165781,159987,166025,166049,164080,159276,166373,166376,166439,166644,166646,166700,166721,166722,166744,166745,166755,166866,166907,166908,153841,166943,166994,167177,167178,167243,167320,167321,164814,167444,167447,166839,167490,167493,167508,167509,167522,167528,167538,167393,167605,167221,167646,167713,167668,167826,167831,167838,167839,167877,167956,167957,167801,167802,167803,167804,167805,167812,158774,155502,168389,166314,168481,168480,168561,168560,168577,168576,168575,166016,166015,167607,166017,168781,164639,164701,168874,168902,155497,150977,168583,169503,169504,169514,169515,163618,166014,150640,170090,170088,170089,170297,170302,170303,170460,156644,167764,163847,170663,170822,170932,170973,170974,170975,170976,168573,170298,168544,171814,171831,171841,171843,171844,171888,172127,172128,172129,172135,172136,172138,173012,172940,173326,173966,173991,173993,173995,174002,173717,170983,170782,174752,174753,174925,173765,172122,173543,173546,170985,172123,174634,175253,172125,173545,175915,175861,175854,175834,175829,174949,176073,178137,168981,175977,173096,177955,168227,178082,178442,176877,175909,177857,178701,179957,177760,173549,178120,178122,178123,180700,180690,180542,180348,173294,173625,173994,181624,181625,181626,181627,181628,181629,181688,181780,180916,177249,181394,178020,181668,173547,182446,182447,169381,184086,182519,182520,175219,184287,174382,185285,183955,177956,183588,168557,185604,186121,186122,182846,178121,173544,172412,180915,174383,174384,180938,185167,185925,185164,185165,184117,174950,183590,183615,187114,187442,187443,185168,171845,180830,185610,185443,185612,185245,185861,175853,185067,175862,185482,185932,185933) AND ur.satis_durumu=1 AND ur.marka_id in (5,118365,578,52) 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;--> <--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 (173927,178906) AND ur.satis_durumu=1 AND ur.marka_id in (5,118365,578,52) 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;-->