<--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 (21468,23433,23787,25152,25154,25463,25469,25470,25473,25478,25481,25483,25497,26096,26140,49580,26974,27050,49579,27885,28728,28808,27986,19387,29463,30064,30063,30241,30647,30648,30650,30747,30817,30878,30883,30885,30886,30888,30891,30776,31740,31741,31894,31891,32083,32082,32076,32075,32073,32174,32195,32218,32722,33010,33011,33014,33099,33116,33269,34510,34512,34513,34516,34517,31700,31594,31592,31593,32436,32250,33586,32133,30030,30029,30028,34674,30998,32000,33592,34514,34667,32228,32251,33007,33272,30040,34945,35050,33660,32647,33659,29464,35577,29847,29952,29945,29944,33661,33663,33662,35799,35831,33596,35827,35825,35819,49105,48568,48387,47704,43377,35377,49100,49102,49376,77394,77393,51049,50792,50791,50553,77480,50342,77716,49101,48999,48569,48564,48559,48958,48870,48565,47111,45200,34703,34091,33568,31210,77732,77725,28951,78268,78469,77729,24430,50793,28814,77414,79486,45069,80380,79469,30092,80803,80805,80808,81272,81491,81628,81386,81537,82100,82101,80010,80139,82133,46948,82131,81477,34515,148024,148229,78578,148227,148377,148605,82472,150276,150452,148023,150451,150794,151747,152088,32077,30748,152086,152089,152090,79727,34947,82144,34946,77736,22433,33270,152742,152644,151711,150563,150281,148397,80713,80138,77730,46800,44955,25155,30778,153628,154252,153636,155508,154910,158773,158772,157977,157968,157964,157933,157076,157055,156304,156082,156041,156038,155693,155692,155691,155687,155570,155511,155510,155509,155475,155316,158779,155160,154494,154222,152904,152632,150554,150303,150302,150301,148819,148020,82453,82141,82134,81653,81627,81625,80807,80092,50325,31999,30508,30348,28918,24337,158817,150063,156887,154517,155512,159124,159468,159511,160250,156076,35729,77717,29863,159779,161049,161851,159063,159060,155881,155099,162288,162286,157966,157963,156043,156040,153889,161248,160388,160175,155501,152752,162423,161743,160891,158033,154911,150082,82140,35850,150821,163252,163251,163072,163008,162694,162334,162333,162175,162130,162084,162083,162072,162069,162068,161990,161988,161933,161914,161200,161149,160214,160213,160027,158488,158447,158223,158222,158221,157495,157494,157493,157491,157490,157320,157319,157078,156994,156732,156470,156469,156463,155926,155925,154688,152104,152103,150547,150546,148398,152556,148396,148380,148378,77481,47878,45180,32551,32173,23729,23727,156323,156322,155561,155560,155558,154778,154777,154776,154774,154425,154424,154423,154399,153601,153600,153599,153598,152314,152313,152312,151750,151749,150652,150453,150450,150039,149926,149921,149578,148632,148604,148231,148230,82553,82552,82551,81815,80993,78267,77586,77392,77313,47844,32078,30239,29866,163508,163507,163497,163557,163556,163567,163569,163574,156039,157969,157965,157970,34422,163827,160093,163933,163927,164084,164289,164231,164230,164229,164228,164309,162058,164460,164984,164983,165040,164459,165224,165227,165229,164830,164836,165465,165469,165561,165619,165748,165749,157975,157976,165864,166006,166023,164232,166135,166136,166340,166341,166288,166299,162825,166831,166923,167089,82132,167145,166996,167307,152022,163071,163250,167445,166850,167803,167804,167850,163283,161506,155792,155108,162287,167206,164227,168189,168313,168405,168406,77731,168834,168785,167143,168876,168877,168878,168879,168899,155497,169166,148228,166003,169437,169084,170019,165495,170092,170091,170441,170442,168744,169047,170865,171818,172065,169087,169085,172573,172574,172575,172576,172577,172265,166402,172923,172997,172998,172999,167759,173755,173757,173756,173927,173932,173957,174232,174322,174340,174388,155569,156042,157981,174772,157967,174632,175378,175377,175906,171842,175835,176304,176434,176433,174751,173754,163845,176126,176523,177138,167144,173100,178158,172299,169086,178302,178785,178789,178790,178817,179408,167741,179999,180154,180829,180828,180999,181128,181129,181780,181779,181781,181782,181686,178170,182644,168381,160598,180953,184589,184588,184587,184586,184583,184581,184580,184657,184916,185557,182101,186396,185873,186908,176438,181390,178698,181391,156030,161073,161783,161782,161249,160176,159160,165781,166644,167801,167812,168560,168696,168752,168874,169503,169515,170302,170663,170822,170298,171728,171831,171948,171997,171998,171999,172000,172110,172126,172127,172128,172548,172605,172991,173323,173383,173465,173466,173470,173760,174771,174883,175904,175996,175997,176054,176055,176309,176310,176313,176446,176447,176513,176591,176592,176593,176810,175253,175861,180644,181470,181842,184971,184993,175219,185076,168557,186376,186729,187114,187800) AND ur.satis_durumu=1 AND ur.marka_id in (5,578) AND (ur.bayi_id='0' or ur.bayi_id='69153') JOIN urun_kategorileri uk ON ur.id = uk.urun_id and uk.kategori_id = 1810 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 (171845,176438,180830) AND ur.satis_durumu=1 AND ur.marka_id in (5,578) AND (ur.bayi_id='0' or ur.bayi_id='69153') JOIN urun_kategorileri uk ON ur.id = uk.urun_id and uk.kategori_id = 1810 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;-->