<--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 (151307,158770,162821,164844,166296,166144,166375,162763,163048,166082,175387,175399,180103) AND ur.satis_durumu=1 AND ur.marka_id in (5,432,21628) AND (ur.bayi_id='0' or ur.bayi_id='3634') JOIN urun_kategorileri uk ON ur.id = uk.urun_id and uk.kategori_id = 1817 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 (79578,78611,78598,47787,31364,30692,26884,26883,22639,22489,20079,19290,19287,50406,15451,50678,31085,12240,26134,25255,24891,24889,10488,29986,3964,3946,31786,50173,44998,15778,25933,34881,49636,15777,22650,15775,18257,27269,48872,30635,48871,50677,35856,18695,13467,50703,50702,28294,80130,77884,49109,149794,149889,149888,149886,149885,80052,151227,151307,151293,10524,10525,24890,153927,153904,153901,156179,157413,158771,158770,159081,78876,160392,160391,160390,160389,160719,160733,160731,160732,162516,162864,162821,163048,163594,162515,165595,165050,165016,166611,166622,167077,167100,167292,167825,168291,168294,168331,168332,168396,168411,168532,166082,170813,174324,174714,174889,175364,175386,175387,175399,175388,175550,177750,178653,180101,180934,180937,180945,181042,181116,181117,181449,181639,181640,181701,182047,181758,166770,169290,185242,186512,186513,186724,185243,187202,187485,187488,187745,187818) AND ur.satis_durumu=1 AND ur.marka_id in (5,432,21628) AND (ur.bayi_id='0' or ur.bayi_id='3634') JOIN urun_kategorileri uk ON ur.id = uk.urun_id and uk.kategori_id = 1817 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 (151307,158770,162821,163048,166082,168234,168233,168231,169414,170777,169292,169291,175387,175399) AND ur.satis_durumu=1 AND ur.marka_id in (5,432,21628) AND (ur.bayi_id='0' or ur.bayi_id='3634') JOIN urun_kategorileri uk ON ur.id = uk.urun_id and uk.kategori_id = 1817 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;-->