<--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 (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,153173,153523,79548,150783,81374,162675,80992,78605,166442,168151,169073,50319,30755,169277,170920,172762,172763) AND ur.satis_durumu=1 AND (ur.bayi_id='0' or ur.bayi_id='14060') 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 (78623,78606,79549,79547,79543,78958,78951,78954,78960,78878,78199,78959,79495,78955,77687,52641,77686,52556,78259,35796,34598,78956,34596,52912,33379,50629,50432,52516,78198,50313,78197,49543,50293,49277,52517,48389,33381,33363,33378,33360,33358,32661,31915,28912,30625,33359,29681,78957,5952,3706,78879,5004,50314,5954,78195,11429,11430,14342,78952,29659,33362,33356,33357,23074,26157,22019,23868,18941,26163,78950,79429,79731,80005,79427,50661,52910,33365,48364,33183,78196,50507,52521,81584,78081,30367,49329,49323,148197,148196,148272,148274,148278,148777,148775,148774,148773,148776,148792,148793,148796,148795,148791,79354,81889,45338,81751,82350,33136,77924,148658,50315,148273,49540,148659,23984,77689,79529,48285,30337,14847,22036,77386,49539,21050,148794,149351,149348,78880,149801,148980,150910,151156,78194,152064,152063,152164,152163,149858,78883,78884,150776,150911,150777,151482,151267,150778,150912,150784,150785,150767,150780,150914,78448,150787,151725,150636,150789,151724,150913,151726,152810,153024,153023,153022,153021,153020,153019,153017,153016,153063,153062,153061,153060,77645,153157,153571,153573,153648,153649,153650,153637,154071,154072,153622,154377,154380,154381,154544,48391,153672,154525,154818,154819,154820,154934,154586,155017,155018,155163,155164,154086,155745,155748,155747,155788,156109,156111,155076,155870,155869,154308,52636,49283,156897,157062,157094,156874,157107,158178,158176,158174,158173,158149,158148,158147,158145,158144,158141,158139,158134,158072,52736,158135,78887,159042,159041,158780,154923,158929,158928,158927,158926,158922,158921,159461,159459,159463,155075,153741,159823,159824,159826,159790,159794,159796,159797,159800,159801,159802,159803,159804,159807,159808,159787,160543,160630,161293,161470,161471,161513,161619,161622,161621,161620,161618,159534,161898,161899,150779,162174,162304,162381,149800,159713,159711,159712,159710,159709,162540,162541,162543,162545,162552,162622,162679,162678,162675,162789,163204,163352,163347,162544,162177,163628,152645,163634,164105,164101,164174,164176,164202,79415,164465,164508,164573,164541,164540,165453,164390,165246,165247,165248,165249,165250,165251,166062,166061,166091,166298,166481,166798,166800,166803,166804,166816,166825,166824,166823,166822,166821,166260,166258,166252,166815,166817,167187,167196,167198,167199,167405,167407,167408,167406,167649,167651,167653,167657,167659,167658,168219,168220,168223,166442,166443,166802,161971,166797,168813,168814,168817,168818,168892,166251,164175,169073,169269,169271,169272,169278,169275,169277,168588,169634,169632,169635,169760,169270,166253,167337,167338,170494,170844,159285,157273,170908,170905,170912,170911,170913,170910,170909,170920,170919,170918,170924,170923,170922,170921,171757,171811,171812,171813,171984,164104,170884,148275,170885,159265,172648,170934,170915,170914,170907,170904,172798,172800,172762,172760,170492,173500,173696,173684,173685,174006,174007,174568,174574,174575,174576,174580,174581,174856,174855,168812,177086,177084,177087,177083,177080,177082,177074,177081,177076,177079,177072,177071,177067,177066,177065,177070,177064,177063,177078,177077,177075,177196,177527,177529,177530,164574,177844,177845,177847,177002,170906,176999,177003,178306,178474,178507,178952,178953,178960,178962,178964,179802,179797,179804,179803,181152,181151,167188,172763,181811,181813,181808,181885,181810,177846,167655,168815,183033,183013,183012,182243,182244,182247,178958,170925,173154,173156,179798,183226,184665,184666,184664,184667,183225,183224,50319,184371,184372,177068,177197,187075,187074,187214,187213,187212,187211,187210,187209,78201,35802,49331,49330,48863,49326,48861,48960,30750,11105,11432,26831,79854,49597,48395,148281,148478,80410,28413,22429,26167,12380,81779,150879,28412,148803,26169,77385,22037,148804,78877,149917,49324,35806,78202,78885,78886,150781,150782,151727,151728,151729,150790,152970,153095,150766,153501,153646,153647,14928,154927,154922,153173,155738,155773,155772,156110,156112,158138,158136,158130,158075,153523,79548,150783,81374,52732,158630,159044,159043,159827,159828,159165,159457,159164,159458,161076,161165,161285,161473,161472,161772,161164,162542,162546,162549,162550,162676,163205,164172,164173,80992,164188,164195,164203,164186,164185,164201,164190,48862,78605,165049,165610,148805,166805,166806,166807,166808,166809,166799,168151,77181,168895,168896,168897,169130,150788,170768,170916,170917,172228,173133,174001,173132,169766,174584,174583,174585,174586,176437,158162,177058,177059,177851,177848,177849,178957,178956,177852,181154,181153,179796,181532,181534,181903,181809,181807,181814,177853,176436,180651,180652,180649,180650,183332,30755,183712,186728,187057,187223,186437,187602,187796,187795) AND ur.satis_durumu=1 AND (ur.bayi_id='0' or ur.bayi_id='14060') 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,29658,27993,33699,33695,48392,48390,48363,48362,35352,34212,33369,44725,50435,50433,50436,50659,49607,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,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,167195,167403,169277,169279,170920,174431,185454,167204,172762,176992,176998,172763,183011) AND ur.satis_durumu=1 AND (ur.bayi_id='0' or ur.bayi_id='14060') 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;-->