<--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 (25237,149741,149894,149890,159723,163051,163047,166795,166072,171707,175383,175385,175393,175395,175397,177098,149897) AND ur.satis_durumu=1 AND ur.marka_id in (5,217) AND (ur.bayi_id='0' or ur.bayi_id='57890') JOIN urun_kategorileri uk ON ur.id = uk.urun_id and uk.kategori_id = 2030 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 (13856,25669,12610,25257,25237,28837,26912,26062,26061,26060,26058,25664,24645,22479,21332,19295,18128,18125,18123,16067,15779,14536,13245,28747,18553,17724,26864,30158,30914,31083,32048,32302,32435,12351,48215,49110,48216,32098,30636,32115,44958,44956,49267,48162,47890,47731,46101,45339,14043,50669,50679,50815,50676,50670,26253,79419,80131,81173,20675,149741,149740,149897,149896,149895,149894,149892,149891,149893,149890,25240,49422,152235,151074,10516,153903,153902,153900,153899,155705,156002,156246,156113,156073,157081,157412,157835,157834,157833,158738,159724,159723,160355,160736,79094,158602,153096,31922,31925,161289,161423,156526,163051,163047,163589,163587,165020,165046,166094,166708,166795,166072,170800,170801,171707,172158,175384,175383,175385,175394,175393,175396,175395,175398,175397,175440,175896,177098,177150,177149,177148,177490,174436,178411,180100,181607,183238,180099,184661,185694,185706,185659,186511,186516,186517,186520,186519,186525,186524,186527) AND ur.satis_durumu=1 AND ur.marka_id in (5,217) AND (ur.bayi_id='0' or ur.bayi_id='57890') JOIN urun_kategorileri uk ON ur.id = uk.urun_id and uk.kategori_id = 2030 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;-->