<--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,48362,35352,34212,50433,50758,52634,35796,52912,50432,33358,31915,47653,47511,30367,148658,49540,148794,78880,148804,150778,150912,150789,150790,152810,153018,153173,79548,150783,81374,162675,77647,79549,48365,82349,148659,150914,153023,153062,153649,153650,154087,154378,154819,154820,154922,154086,155745,155076,155870,156897,156747,157697,158178,158177,158139,158136,158072,158135,159043,159041,159029,158781,158780,159229,158926,158923,158922,158921,157983,159461,153741,159823,159804,159806,159165,159458,161471,159711,159704,162549,163204,164105,164173,165453,166808,166828,166822,167181,168223,169293,167337,172228,164104,148275,172646,170907,177071,177065,177070,177849,178306,178474,179100,187075,187795,161898,164197,164202,164465,165248,165249,165254,165255,166815,167196,167651,167652,167657,167658,168809,168810,168813,168897,169634,169631,170933,170911,174004,173132,174584,174574,174581,168812,176437,177084,177078,177527,164574,178956,178959,167188,181902,181813,177846,180651,184101,178958,184125,184371,187210,161899,164554,164555,165250,165251,165256,165257,167405,167407,167408,167406,167653,167654,167659,167660,169271,169273,169632,170912,170934,174005,174422,174856,177087,177079,177002,174428,177000,178962,178963,179797,179119,183034,183036,183013,183012,182243,182244,184103,184665,184666,184664,184667,184102,187215,187214,187213,187211,187336,187345,170921,177638,174564,176996,176994) AND ur.satis_durumu=1 AND (ur.bayi_id='0' or ur.bayi_id='35034') 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 (77178,48960,148804,35806,151729,150790,153095,153501,153647,154927,154922,153173,155773,156110,158138,158136,79548,150783,81374,159043,159165,159458,162549,163205,164173,164186,164185,164190,165610,166806,166808,168896,168897,170768,172228,174004,173132,169766,174584,174583,176437,177849,178956,177852,181809,181902,180651,180649,183332,183712,187795) AND ur.satis_durumu=1 AND (ur.bayi_id='0' or ur.bayi_id='35034') 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 (49330,80410,81779,148803,77385,148804,78877,49324,78202,78885,78886,150781,150782,150790,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,187057,186437,187796,187795,168897,170917,173133,174004,173132,174584,174586,176437,178957,178956,181534,181902,181814,176436,180651,180652,187223,187602,174003) AND ur.satis_durumu=1 AND (ur.bayi_id='0' or ur.bayi_id='35034') 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;-->