<--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 (163131,153889,162686,161295,161249,161248,160388,160218,160175,159368,159223,159160,159033,158778,156575,155706,155501,155206,155010,153745,152752,163070,163069,163068,162423,162385,161743,160894,158840,160892,160891,160883,160572,160002,159999,159971,159372,159198,159197,159154,159022,158829,158803,158742,158702,158378,158372,158284,158033,157809,157794,156914,156693,156671,156482,155552,155319,155318,154911,154803,153537,153353,153333,153295,153034,152751,152750,152746,152745,152304,150082,19746,149188,82145,82140,79730,35850,150821,154141,154140,154038,163252,163251,163072,163008,162693,162692,162638,162334,162333,162332,162322,162175,162130,162083,162072,162069,162068,161990,161988,161933,161915,161914,161213,161202,161200,161149,160600,160589,160520,160214,160213,160148,160027,159374,159058,158448,158446,158223,158222,158221,157495,157494,157493,157491,157490,157430,157320,157319,157183,157182,157140,157138,157137,157078,157075,157074,157073,157072,157071,156994,156732,156694,156470,156469,156468,156463,155927,155926,155925,155924,154691,154690,154689,154688,154187,154186,152230,152104,152103,152102,150547,150546,152556,152458,148396,148380,148378,77481,47931,47878,45180,32551,32173,23729,23727,156323,156322,155561,155560,155559,155558,155535,155274,155098,154834,154778,154777,154776,154774,154425,154424,154423,154399,153601,153600,153599,153598,153001,152314,152313,152312,151750,151749,150652,150453,150450,150334,150277,150039,149578,148632,148604,148231,148230,82552,82551,82325,80993,78267,77586,77392,47844,30239,29866,163548,152828,152829,163557,163556,163567,163568,163569,163573,163574,156039,157969,157965,157970,34422,163565,163566,163827,160093,163927,163959,163935,163997,163954,164084,164290,164289,164291,157522,164231,164229,164228,164396,164397,162737,164309,164507,164460,164577,164578,164292,157521,164700,164798,164797,152363,160893,164816,164905,164904,164903,164902,164984,164983,164459,164813,155013,165224,165227,165229,164830,164831,164836,165465,165469,156472,165543,165619,165714,165748,157080,165749,165784,165783,165782,157975,157976,152685,152830,154341,152703,165887,165787,165781,159987,166023,166030,164232,164080,166135,166136,159276,166340,166341,166288,166299,166476,166482,162825,166022,166343,166041,166750,166720,166777,166831,166923,166339,166996,167152,167160,166176,159023,167307,158777,167109,158775,152022,77734,163071,163250,164814,167202,167190,167189,167415,167445,166839,167490,153475,167393,157139,166850,167668,167682,167801,167802,167803,167804,167805,167812,167850,158774,161506,155792,155502,167206,167191,167200,167205,164227,167208,168189,168013,168012,168080,168081,168389,160092,155537,165754,165753,163999,163998,159997,160895,168561,168560,168406,168577,168576,168575,166016,166015,167607,166017,167989,77731,168781,168834,168780,168784,164639,164701,168779,168822,168876,168877,168878,168879,168874,168875,168901,168902,155497,150977,168732,168992,169027,169033,49099,148228,168583,169363,169364,169365,169503,169504,169514,169515,169535,169536,169537,168747,163618,166014,168600,168612,161746,153000,169084,150640,155496,170019,169925,170090,170088,170089,170092,170091,170297,170302,170426,170303,170441,170442,170460,156644,168744,169047,170841,170865,168240,167764,163847,170663,170822,170932,170973,170974,170975,170976,168573,170298,168544,171703,171827,171814,171831,171841,171843,171844,171888,171979,171939,168442,169087,172116,172126,172127,172128,172129,172135,172136,172138,172240,169085,172238,172265,168459,172684,172340,172341,172923,172997,172998,172999,167759,173079,172839,173012,173114,172940,173093,173326,173330,173354,173355,170984,173740,173755,173757,173756,173932,173957,173966,173967,173973,173974,173991,173992,173993,173995,174002,174144,174145,174233,174252,174322,174368,155569,156042,157981,170983,174781,170782,157967,174632,174752,174753,175122,175123,175124,175125,175126,175279,175378,156471,175377,175606,175595,175602,175605,175603,163981,175604,171842,175735,173765,176032,176028,176041,176152,176040,172122,176031,176033,176037,176036,176304,176431,176312,176492,176493,176512,176442,176439,176434,176433,176432,176817,176875,176426,173543,173546,170985,172123,174634,175253,172125,177127,177128,159059,176430,153002,167203,177116,177117,176429,173568,177321,177322,155931,177559,166849,173545,174751,173754,163845,176126,175915,177647,177648,177690,177688,177689,177501,177502,175861,175854,176021,175834,175829,174949,173550,173085,176073,178029,178030,178137,178190,178191,178192,178193,177138,177766,178423,173167,168981,175977,173096,173100,173609,177955,177930,168227,178082,178442,172299,173327,160149,178586,178599,178605,178613,178614,178617,178618,178619,178302,178815,178816,176877,178827,178931,178906,175909,179426,179364,179558,178907,179627,179628,179629,179759,177857,179538,167741,178701,179957,179594,179999,180185,177500,176129,176928,177251,175144,177760,173549,178120,178122,178123,180661,180825,180829,180828,180826,177332,180633,180064,180542,180999,181156,173294,173625,173994,181624,181625,181626,181627,181628,181629,181648,181688,181827,181828,181829,181784,181780,181779,181781,181782,181686,182277,182278,182269,182267,182268,182265,182266,182264,178170,182660,180916,182646,182630,182644,183098,168381,177249,181394,178020,160598,183884,184135,184136,184137,184138,181668,184271,184272,173547,184411,184412,184413,184414,180953,182446,184657,182447,169381,184916,184920,184918,177412,184086,182519,182520,175219,184287,172095,184922,174382,185173,185285,185290,183955,177956,183588,185557,168557,172496,185604,185875,182101,186121,186122,182846,185873,172412,180915,174383,174384,180938,185167,185925,185164,185165,184117,174950,183590,183615,185606,187114,187157,185874,187439,187438,187442,187441,187443,187440,171845,176438,183587,181390,174681,185610,185443,185612,185245,185861,175853,178031,185067,173285,181391,175862,185482) AND ur.satis_durumu=1 AND ur.marka_id in (5,75,21628,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 = 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 (49577,49580,30347,30647,30648,30776,31767,31891,32076,32075,32073,32722,33010,33011,33014,33099,33116,34510,34512,34513,34516,34517,31594,31592,31593,32250,33585,33592,34514,32228,33007,33272,31215,29847,29886,29952,29945,29944,35799,35831,35827,35825,49106,44578,48387,45114,44950,43377,49579,50249,49100,49376,44949,77393,51049,50792,50791,77480,50342,77735,77716,49104,49101,49098,48564,47111,45701,48091,47938,47604,34704,34091,33568,31210,77726,77732,57535,77725,78469,50793,28814,49380,79486,77945,45069,79469,30092,81272,81491,81628,82100,82101,80010,80139,82133,82131,34515,148024,148229,148379,148377,148515,148513,148514,82472,150276,148023,151747,152088,78472,81117,150335,30748,152086,152089,152090,80826,79727,150775,34947,150773,82144,32962,34946,150772,77736,22433,79729,33270,77724,152747,152644,151711,150563,150281,148397,148376,80713,80138,77730,46800,44955,25155,153106,149718,30778,153628,153726,149978,155508,156473,150332,158772,157968,157933,157076,156304,156038,155793,155693,155692,155691,155687,155570,155511,155510,155509,155498,155475,155316,158779,155160,154494,154222,154185,152904,152632,152135,150774,150303,150302,150301,149022,148395,148020,82147,82141,82134,81653,81627,81626,81625,81116,80092,79728,50325,35411,31999,30508,30348,24337,158817,150063,156887,155512,159124,155611,151735,159511,159748,160250,160348,156923,35729,77717,29863,161776,157513,157181,157180,157054,155097,163131,162288,160094,153889,151365,162686,160388,155706,155501,155010,162423,159022,158803,158702,158378,157809,152746,152745,19746,149188,79730,35850,154140,163251,162692,162690,162334,162333,162175,162084,162072,162069,162068,161990,161915,161914,161213,161212,161202,161201,160600,160589,160520,160214,160213,160148,159374,159058,158002,157430,157183,157182,157137,157072,157071,156732,156694,156469,156468,156463,155926,155925,154690,154689,154688,154186,152230,152104,152103,152102,150547,150546,152458,148396,148380,148378,77481,47878,45180,32551,32173,23729,23727,155558,154399,153601,153600,153599,153598,153001,150334,150277,149921,148604,82552,82551,82325,80993,78267,77392,77313,47844,32078,30239,29866,163508,163507,163497,163557,163567,163569,163573,163574,157965,34422,163827,160093,163933,163959,163954,164290,164289,164291,157522,164228,162737,162058,164577,164292,157521,164700,164984,164983,164813,165227,165229,165465,165469,156472,165561,165562,165564,165543,165619,165748,165749,157975,157976,152685,165787,166023,166136,166476,166482,162825,166022,166041,166750,166720,166777,166831,166923,82132,167152,167160,166176,159023,167307,158777,167110,167109,158775,152022,77734,163071,163250,167445,167490,164315,153475,167850,158774,160092,168366,168365,168576,168575,166016,166017,167989,77731,168834,168822,168876,168877,168878,168879,168875,168901,169027,169033,49099,168583,169363,169364,169365,169535,169536,169537,153000,169084,150640,165495,170441,170442,170841,170865,168240,168573,171703,171827,171979,168442,169087,169085,172238,168459,172684,172340,172341,166402,172923,172997,172998,172999,173114,172940,173354,173355,170984,173514,173740,173755,173757,173756,174144,174145,174233,174252,174322,155569,157981,157967,175122,175123,175124,175125,175126,77733,156471,175595,175602,175605,175603,163981,176032,176031,176304,176312,176492,176493,176442,176439,176434,176433,176432,176817,176426,173543,177127,177128,153002,177117,173568,177321,177322,155931,177559,163845,177647,177648,177689,177501,176021,173550,178029,178030,178190,178191,178192,178193,177766,178423,173327,160149,178586,178599,178613,178614,178617,178618,178619,178906,179558,179627,179628,179629,179759,179538,167741,179999,180185,176928,175144,173549,178120,180661,180824,177332,180633,180064,181156,173625,181784,182277,182278,182269,182267,182268,182265,182266,183098,168381,160598,183884,184135,184136,184137,184138,184411,184412,184413,184414,180953,184920,172095,184922,183955,185875,187157,185874,187439,187438,187441,187440,176438,183587,174681,185245,185557,185610) AND ur.satis_durumu=1 AND ur.marka_id in (5,75,21628,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 = 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;-->