<--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 (26061,26060,22479,19295,31083,49110,44958,44956,77914,79419,80122,149897,149896,149895,149894,149892,149891,149893,149890,10516,175394,175393,177149,177148,186527,32098,14043,50679,50670,160353,160736,160352,160324) AND ur.satis_durumu=1 AND ur.marka_id in (5) 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 (12610,28747,26912,26062,26061,26060,26058,26057,26051,24645,22479,21332,19295,18553,18128,18125,18123,17724,16067,15779,14536,13245,25664,30914,32048,32302,12351,49110,48215,48216,13856,32098,30636,32115,44958,44956,48162,47890,47731,46101,45339,14043,50669,50679,50676,50670,26253,78235,79419,149897,149896,149895,149894,149892,149891,149893,149890,58207,49422,151074,10516,153902,153900,153899,155705,156002,156246,157081,157412,160736,79094,31922,161289,161428,161423,161429,160352,160324,163051,163047,163589,165020,162863,169413,171707,175398,175397,175896,177150,177149,177148,178411,178792,181272,181704,181706,181834,181607,180099,184661,185694,185706,185659,186409,186517,186519,186526,186525,186527,186786) AND ur.satis_durumu=1 AND ur.marka_id in (5) 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;-->