<--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 (80410,81779,148803,77385,148804,78877,49324,78202,152970,153173,153523,79548,150783,81374,80992,78605,168151,30755,148478,150879,149917,153095,153501,153646,153647,154927,155773,155772,156110,156112,158138,158130,158075,158630,161285,161473,162542,162676,163205,164203,164190,166805,166806,166802,150788) 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 (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,28721,28965,78953,78951,78878,50314,79429,79731,80005,82300,148281,148775,148792,148478,151156,78194,152064,152163,149917,151728,151725,150913,153646,155163,155772,156111,156112,158630,150779,162676,164101,164203,166803) 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 (148478,28412,148803,26169,77385,22037,149917,49324,153646,155738,155772,156112,153523,52732,158630,159828,159457,159164,161076,161472,161772,161164,162676,164172,164203,78605,148805,166800,166807,168151,77181,170916,170917,158162,177058,177848,181153,179796,181807,30755,186728) 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;-->