<--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 (33700,33699,33696,34212,35352,33372,77646,77647,52634,79495,52912,52910,30367,82349,148660,153063,153062,153061,153650,154092,154091,154820,153242,157697,158178,158177,158139,158135,157419,158780,159229,158929,158926,157983,159461,159796,159798,161619,161621,161898,161899,164105,164197,164202,164186,164545,164555,165247,165249,165251,165255,165257,166828,167194,167195,167204,167182,167187,167196,167198,167199,167405,167402,167403,167406,167657,167656,167659,167660,167658,167186,168807,168808,168809,168810,168811,169293,169271,169273,169278,169275,169277,169279,167337,167338,170494,170495,170912,170911,170913,170920,170919,170918,170921,172103,172101,170915,170914,170904,172758,172762,172760,174004,174005,174423,174422,174564,174856,177084,177087,177082,177074,177071,176996,176992,176994,177635,177636,177637,177639,177002,177638,174427,174428,177000,174431,174430,178507,179103,179100,179797,179803,172097,167188,167404,182241,167655,183036,183011,184101,179798,184103,184125,184665,184666,176993,185454,184102,187214,187213,187212,187336) AND ur.satis_durumu=1 AND ur.marka_id in (5,217,1163,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 (28787,27993,33699,33695,48392,48390,48363,48362,35352,34212,33369,44725,50435,50433,50436,77651,52634,47712,46018,78959,77686,34598,52912,50432,48389,33381,33358,33359,78957,78952,33357,78950,50507,30367,148793,45338,50315,148273,148794,78877,151482,150912,153021,153018,153173,153523,162675,161898,164197,164202,164548,164549,165248,165249,165254,165255,167196,167651,167652,167657,167658,168809,168810,168813,169634,169631,169760,170933,170911,170910,170923,171757,172099,174004,174425,168812,177084,177083,177078,177077,177527,174432,178960,178959,178961,179118,167188,184101,178958,184125,184371,184372,187210,167194,167187,167402,169278,169275,170914,173687,174423,174430,178507,179802,167404,183033,183035,170925,179798) AND ur.satis_durumu=1 AND ur.marka_id in (5,217,1163,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,52634,52912,30367,161898,164197,164202,164465,165249,165255,167196,167657,167658,168809,168810,170911,174004,174581,177084,167188,184101,184125,167194,167187,167402,169278,169275,170914,174423,174430,178507,179114,167404,179798,183225) AND ur.satis_durumu=1 AND ur.marka_id in (5,217,1163,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;-->