<--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 (29658,48390,50435,50436,50659,49607,47712,78606,77686,52556,78259,34598,50629,49330,48389,33381,78952,33357,78950,79636,48002,50507,49329,49323,148793,148796,148795,33136,77689,48285,30337,77386,148980,80410,81779,148803,77385,78877,49324,78883,78885,78886,78884,150776,150781,150777,151482,150782,153021,153523,80992,78605,166442,168151,169073,50319,30755,28721,78953,78951,50313,50314,79731,80005,82300,148281,148775,148792,148478,151156,78194,152064,152164,152163,150879,149917,150911,150787,151727,151728,151724,150913,153646,155163,155772,156111,156112,158630,161285,161473,150779,162541,162676,164101,164203,166298,166803,166805,166802,150788) AND ur.satis_durumu=1 AND ur.marka_id in (5,50,1218) AND (ur.bayi_id='0' or ur.bayi_id='34823') JOIN urun_kategorileri uk ON ur.id = uk.urun_id and uk.kategori_id = 1750 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 (22814,22815,22823,23002,28405,28406,28708,28721,29658,30767,30899,32139,32140,32141,32142,32145,32146,32052,32663,32664,32665,33135,30008,35795,48390,48388,49333,48361,44726,49327,49325,49705,50332,50435,50431,50430,50425,49606,50436,50659,44978,49607,49605,49544,77388,77988,47712,78623,78606,78953,78951,79527,78954,78955,52641,77686,52556,78259,34598,78956,34596,33379,50629,52516,50313,78197,50293,49277,48389,33381,33378,28912,29681,78879,50314,11430,14342,78952,29659,33356,33357,23074,26157,22019,23868,18941,26163,78950,79731,80005,50507,52521,49329,49323,148196,148274,148277,82300,148775,148776,148788,148790,148792,148793,148796,148795,148791,79354,33136,148593,23984,77689,79529,48285,30337,14847,22036,77386,49539,21050,149351,149348,149801,148980,150910,151156,78194,151805,152064,152164,152163,78883,78884,150776,150911,150777,151482,151267,78448,150787,150636,151724,150913,153021,153020,153017,153571,153648,154067,153672,155017,155163,155164,155748,155746,155788,154549,154547,156111,155871,52636,49283,158175,158173,158071,158069,158068,52736,159028,158783,155075,159826,159791,159794,159795,159807,159808,160543,161293,161470,159534,150779,162304,152813,152814,159709,162541,162545,162552,162679,162678,162623,162177,163628,164106,164101,164174,164550,164540,164181,166061,166298,166798,166800,166803,166824,166821,167180,168220,168221,166442,166443,166802,161971,166797,168817,168818,164175,169073,169636,159271,171811,171812,172096,170884,159270,172798,172800,173696,174006,174007,177064,177063,177529,177530,177844,170906,179109,179121,179118,181151,181808,168815,173155,173157,50319,184372,187074) AND ur.satis_durumu=1 AND ur.marka_id in (5,50,1218) AND (ur.bayi_id='0' or ur.bayi_id='34823') JOIN urun_kategorileri uk ON ur.id = uk.urun_id and uk.kategori_id = 1750 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 (28787,29658,27993,33699,33695,48392,48390,48363,48362,35352,34212,33369,44725,50435,50433,50436,50659,49607,77651,52634,47712,46018,78606,78199,78959,77686,52556,78259,35796,34598,52912,50629,50432,48389,33381,33358,31915,33359,78957,78952,33357,78950,50507,30367,49329,49323,148793,148796,148795,45338,33136,148658,50315,148273,49540,77689,48285,30337,77386,148794,78880,148980,78883,78884,150776,150777,151482,150778,150912,150789,152810,153021,153018,162675,166442,169073,50319,26233,28721,28965,32819,35812,29774,50664,78953,79547,78958,78951,78960,78878,50313,50314,79733,79732,79429,79731,80005,81584,82300,148775,148773,148792,148232,151156,78194,152064,152164,152163,150911,150784,150780,150787,151725,151724,150913,151726,153022,153019,153016,154544,154818,155163,156109,156111,154308,157062,78887,159824,159800,159803,160630,150779,162381,162541,163347,164101,79415,166298,166803,166804,166802,174564,176996,176994,176995,176997) AND ur.satis_durumu=1 AND ur.marka_id in (5,50,1218) AND (ur.bayi_id='0' or ur.bayi_id='34823') JOIN urun_kategorileri uk ON ur.id = uk.urun_id and uk.kategori_id = 1750 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;-->