<--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,33699,33695,48392,48390,48363,48362,35352,34212,33369,44725,29658,30989,50435,50433,50436,47109,50659,49607,50758,77651,52634,47712,46018,78606,78199,78959,77686,52556,78259,35796,34598,52912,50629,50432,49330,48389,33381,33358,31915,33359,78957,78952,33357,78950,79636,48002,47653,47511,50507,30367,49329,49323,148793,148796,148795,45338,33136,148658,50315,148273,49540,77689,48285,30337,77386,148794,78880,148980,80410,81779,148803,77385,148804,78877,49324,78202,78883,78885,78886,78884,150776,150781,150777,151482,150778,150912,150782,150789,150790,152810,152970,153021,153018,153173,153523,79548,150783,81374,162675,80992,78605,166799,166442,168151,169073,50319,30755) AND ur.satis_durumu=1 AND (ur.bayi_id='0' or ur.bayi_id='14060') 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 (22018,22815,22817,22823,28406,28708,30332,31789,32140,32145,32664,49333,44726,22266,49327,49328,49544,78623,52516,78198,49277,52517,33378,23074,26157,22019,77917,79854,49597,22036,149348,28412,26169,22037,52636,52732,159826,159828,161076,161164,162304,148805,166798,166800,77181,29658,27993,48390,50435,50436,50659,47712,77686,78259,34598,48389,78952,33357,78950,79636,48002,49323,148793,148796,48285,30337,77386,148980,148803,77385,49324,78886,78884,150777,151482,150782,153523,78605,168151,169073,50319,30755) AND ur.satis_durumu=1 AND (ur.bayi_id='0' or ur.bayi_id='14060') 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 (28965,28721,30904,31997,33694,48390,30899,30008,29658,49334,49325,50435,50431,50430,50436,50659,49605,77988,47712,78953,78951,79527,78954,78878,78955,77686,78259,34598,78956,48863,49326,48389,30750,78879,50314,78195,78952,29659,33357,78950,79429,79731,79636,48002,80005,79427,49323,148196,148274,82300,148281,148775,148776,148788,148790,148792,148793,148796,148791,79354,82350,148593,79529,48285,30337,77386,49539,149801,148980,148478,150910,151156,78194,151805,152064,152163,148803,77385,149917,49324,78886,78884,150777,151482,151267,150782,151728,151725,150636,150913,153020,153017,153571,153648,153646,154067,153672,155017,155163,155164,155738,155748,155746,155772,155788,154549,154547,156111,156112,155871,158175,158071,158069,158068,153523,158630,159028,158783,155075,159791,159794,159795,159807,159808,159457,159164,161470,161772,159534,150779,152813,152814,159709,162552,162679,162678,162676,162623,162177,163628,164106,164101,164172,164174,164203,78605,164540,164181,166061,166803,166807,166824,166821,167180,168151,161971,164175,169073,159271,172096,170884,159270,173696,174006,174007,158162,177064,177063,177058,177844,177848,170906,179109,181153,179796,173155,173157,50319,30755,186728,187074,187057) AND ur.satis_durumu=1 AND (ur.bayi_id='0' or ur.bayi_id='14060') 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;-->