<--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 (3514,3348,3492,3493,11607,24686,32660,32662,11104,32661,5952,3706,5004,5954,11105,11429,33183,22264,22266,22018,22815,22820,21052,28406,28708,28721,29658,30332,30899,30904,31997,32140,32145,32052,31789,32664,32665,33694,30008,48390,48388,49333,48361,44726,49334,49327,49325,49328,50435,50431,50430,50436,50659,49605,49544,50699,77388,77988,47712,78623,78953,78951,79527,78954,78955,77686,78259,34598,78956,52516,50293,49277,48863,49326,48389,33378,30750,28912,78879,50314,78952,29659,33356,33357,23074,26157,22019,18941,78950,79731,79636,48002,77917,79854,80005,49597,49323,148196,148274,148277,82300,148281,148775,148776,148788,148790,148792,148793,148796,148791,79354,148593,79529,48285,30337,22036,77386,49539,21050,149348,149801,148980,148478,150910,151156,78194,151805,152064,152163,28412,148803,26169,77385,22037,149917,49324,78886,78884,150777,151482,151267,150782,151728,150636,150913,153020,153017,150766,153571,153648,153646,154067,153672,155017,155163,155164,155738,155748,155746,155772,155788,154549,154547,156111,156112,155871,52636,158175,158071,158069,158068,153523,52732,158630,159028,158783,155075,159826,159828,159791,159794,159795,159807,159808,159457,159164,161076,161470,161472,161772,159534,150779,161164,162304,152813,152814,159709,162552,162679,162678,162676,162623,162177,163628,164106,164101,164172,164174,164203,78605,164550,164540,164181,166061,148805,166798,166800,166803,166807,166824,166821,167180,168220,168221,168151,77181,161971,168817,168818,164175,169073,169636,170916,170917,159271,171811,171812,172096,170884,159270,172798,172800,173696,174006,174007,158162,177064,177063,177058,177529,177530,177844,177848,170906,179109,179121,179118,181153,179796,181808,181807,168815,173155,173157,50319,30755,184372,186728,187074,187057) 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 (5959,3514,3493,32661,5954,11607,22264,22818,22820,21052,24686,32141,32662,32663,32665,48388,48361,23002,50332,50699,50293,5004,11105,11430,11432,18941,14847,21050,12380,78448,160543,161472) 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;-->