<--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 (173795,173801,172716,165845,165844,172715,172671,172672,174474,176303,180191,180188,180176,178491,181776,179986,181775,184166,185542) AND ur.satis_durumu=1 AND ur.marka_id in (5,330,58,124) AND (ur.bayi_id='0' or ur.bayi_id='3634') JOIN urun_kategorileri uk ON ur.id = uk.urun_id and uk.kategori_id = 1777 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 (24974,25373,26674,28666,28674,29708,32737,33209,33210,33251,33252,48242,48240,49657,50255,79500,50283,149928,150648,151041,153966,155589,155899,156634,81301,155225,158103,154506,158741,158740,160227,167035,173807,160824,173794,170289,172717,165843,165846,174042,173802,161364,162753,172718,160150,162754,167036,162774,162757,158739,160615,162535,173782,172067,177030,176240,172670,176311,166230,176319,173261,176235,162755,178471,172669,179983,176233,174464,186857,180191,180188,180176,181776,179986,181775,184171,185544,184166,184165,185543,185542) AND ur.satis_durumu=1 AND ur.marka_id in (5,330,58,124) AND (ur.bayi_id='0' or ur.bayi_id='3634') JOIN urun_kategorileri uk ON ur.id = uk.urun_id and uk.kategori_id = 1777 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;-->