<--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,154922,155738,158136,159044,159043,159165,159457,159164,159458,161165,161772,162549,162550,164172,164173,164188,165049,166807,166808,166809,172228,158162,177058,177059,177851,177848,177849,179796,186728,186437,170768,174583,174585) AND ur.satis_durumu=1 AND ur.marka_id in (5,1182,1218) AND (ur.bayi_id='0' or ur.bayi_id='34823') 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 (33699,35352,34212,33369,47109,77651,52634,52912,30367,48367,77647,48365,82349,153062,153650,154087,154820,155870,157697,158178,158177,158176,158174,158139,158135,159044,159042,158780,159229,158928,158927,158926,157983,159461,159459,161165,162550,163352,164105,165049,164390,166809,166828,166823,167401,167337,170908,159265,172502,177071,177070,177059,177851,178306,178474,179100,173156,187796,161621,164545,165247,167198,167199,167656,168811,166253,170494,170495,173500,174575,174580,174585,177082,178953,178955,167655,187212) AND ur.satis_durumu=1 AND ur.marka_id in (5,1182,1218) AND (ur.bayi_id='0' or ur.bayi_id='34823') 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 (158130,158075,159044,161165,162542,162550,164186,164201,165049,166809,168895,169130,173133,174001,174585,174586,177059,177851,178957,181532,181534,181903,181814,176436,180652,180650) AND ur.satis_durumu=1 AND ur.marka_id in (5,1182,1218) AND (ur.bayi_id='0' or ur.bayi_id='34823') 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;-->