<--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 (20674,13856,26864,12610,25257,25237,28837,28747,26062,26061,26060,26058,26057,26051,25664,24645,22479,21332,19295,18553,18128,18125,18123,17724,16067,15779,14536,13245,3960,30158,30914,31083,32048,32435,12351,49110,48215,48216,30636,32115,44958,44956,26253,77914,78235,79419,80122,80131,81173,20675,149741,149740,149897,149896,149895,149894,149892,149891,149893,149890,58207,25240,49422,151074,10516,153903,153902,153900,153899,155016,155705,156002,156246,156113,156073,157081,157412,157835,157834,157833,158738,159724,159723,160355,160353,79094,158602,153096,31922,31925,161289,161428,161427,161423,161429,156526,160352,160324,163051,163047,163589,163587,165020,165046,166094,166708,162863,166795,166072,169413,170800,170801,171707,172158,174926,175384,175383,175385,175394,175393,175396,175395,175398,175397,175440,175896,177098,177150,177149,177148,177490,174436,178411,178101,180100,181607,183238,180099,184661,185694,185706,185659,186511,186516,186517,186520,186519,186526,186525,186524,186527) AND ur.satis_durumu=1 AND ur.marka_id in (5,1181) 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 (25664,157081,162863) AND ur.satis_durumu=1 AND ur.marka_id in (5,1181) 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;-->