<--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 (3682,3348,5959,3492,3493,3490,22264,22266,22225,22018,11607,22818,22819,22820,22821,23002,21052,26161,26830,28405,28406,1226,29774,30332,30767,30899,30903,30904,30989,31789,31998,31997,32139,32140,32141,32142,32145,32146,32052,32434,32660,32662,32663,32664,32665,32819,33135,33694,33693,30008,35795,48959,48388,48369,49333,48368,48367,48366,48361,29658,49334,49327,49325,49705,11104,49328,50332,50425,49606,23802,23708,48955,47109,44538,50518,50517,33936,50659,44978,49607,49605,49544,50699,50758,77178,77388,77988,30333,78623,78606,79549,79547,78201,78878,78199,52641,52556,78259,35802,35796,34596,33379,50629,78198,78197,49543,49331,50293,49277,49330,48863,49326,48861,48960,33378,32661,31915,30750,30625,29681,5952,5954,11105,78195,11432,29659,33356,26831,26157,26163,79636,77918,48002,47653,47511,77917,79854,48365,49597,33183,78196,48395,49329,49323,148281,148796,148795,33136,148658,49540,23984,77689,48285,30337,14847,22036,77386,21050,149351,149348,78880,148980,148478,78194,152064,152164,152163,80410,28413,22429,26167,12380,81779,150879,28412,148803,26169,77385,22037,148804,149917,49324,35806,78202,78883,78885,78886,78884,150776,150781,150777,150778,150782,150780,78448,150787,151727,151728,151725,151729,150789,151724,150790,151726,152810,152970,153020,153016,153095,150766,153501,153648,153649,153646,153647,154087,14928,155738,155748,155773,155772,156109,156110,156111,156112,155873,155872,155871,155870,155869,52636,49283,156897,158174,158136,158075,158072,52736,79548,150783,81374,158630,159044,159043,159042,159041,159826,159827,159828,159165,159457,159164,159458,160543,160630,161076,161293,161165,161285,161470,161471,161473,161472,161772,150779,161164,162304,162542,162545,162546,162549,162550,162676,163205,163352,163347,164101,80992,164188,164195,164203,164201,164465,48862,78605,164573,165049,166061,166298,164547,148805,166798,166800,166803,166804,166805,166806,166807,166808,166809,166816,166799,166815,166817,166442,166443,168151,77181,166802,161971,166797,168895,168892,168896,168897,169073,169130,169269,169270,150788,170768,170844,170916,170917,170908,172228,172798,172800,173133,173696,174001,173132,169766,176437,158162,164574,177851,177844,177845,177847,177848,177849,178306,178474,178957,178956,177852,181154,181153,181152,181151,179796,179114,181532,181534,181903,181811,181809,181902,181813,181808,181807,181814,181885,181810,177853,177846,176436,180651,180652,180649,180650,183332,183226,183225,183224,50319,30755,183712,186728,187057,187223,186437,187602,187796,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 (11607,22264,22818,22820,21052,24686,32141,32662,32663,32665,48388,48361,23002,50332,50699,50293,5004,11105,11430,11432,18941,14847,21050,12380,78448,160543,161472,22018,22225,22814,22815,22817,22819,22821,22823,22824,22826,24205,26161,28405,28406,28708,30332,31789,32139,32140,32142,32145,32146,32434,32664,35795,49333,44726,32052,22266,30989,49327,49328,50425,48955,49544,78086,78623,52641,33379,52516,78198,78197,49543,49277,52517,33378,11429,14342,26831,23074,26157,22019,23868,26163,77918,77917,79854,49597,33183,52521,48395,23984,22036,149351,149348,28413,22429,26167,28412,26169,22037,150766,52636,49283,52736,52732,159826,159827,159828,161076,161293,161164,162304,162545,162546,164196,48862,148805,166798,166800,166799,77181,166797,28787,29658,27993,33699,33695,48392,48390,48363,48362,35352,34212,33369,44725,50435,50433,50436,47109,50659,49607,50758,77651,52634,47712,46018,78606,78199,78959,77686,52556,78259,35796,34598,52912,50629,50432,49330,48389,33381,33358,31915,33359,78957,78952,33357,78950,79636,48002,47653,47511,50507,30367,49329,49323,148793,148796,148795,45338,33136,148658,50315,148273,49540,77689,48285,30337,77386,148794,78880,148980,80410,81779,148803,77385,148804,78877,49324,78202,78883,78885,78886,78884,150776,150781,150777,151482,150778,150912,150782,150789,150790,152810,152970,153021,153018,153173,153523,79548,150783,81374,162675,80992,78605,166442,168151,169073,50319,30755,26233,28721,28965,32819,35812,29774,50664,78953,79547,78958,78951,78960,78878,50313,50314,79733,79732,79429,79731,80005,81584,82300,148281,148775,148773,148792,148232,148478,151156,78194,152064,152164,152163,150879,149917,150911,150784,150780,150787,151727,151728,151725,151729,151724,150913,151726,153022,153019,153016,153095,153501,153646,153647,154544,154818,154927,155163,155773,155772,156109,156110,156111,156112,154308,157062,158138,158130,158075,158630,78887,159824,159800,159803,160630,161285,161473,150779,162381,162541,162542,162676,163205,163347,164101,164203,79415,164190,166298,166803,166804,166805,166806,166802,150788,167195,167403,169277,169279,170920,174431,185454) 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;-->