<--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 (23433,23787,25469,25470,25473,26142,49580,26974,28809,30063,30800,30817,30887,30891,31741,31894,32083,32082,32076,32174,32192,33269,33354,34516,34517,31700,31592,31593,32133,33585,34674,30815,30998,33592,34514,34667,32228,33272,29871,34945,35050,35799,33596,48387,77480,50342,48569,48870,45701,48091,47938,78566,30092,148229,78578,148379,148516,151747,152089,77736,152743,25155,156473,158772,157077,157076,157055,156041,155570,155510,155509,155475,155273,154185,149022,150063,156887,154517,151735,157079,161781,161778,162321,159063,159060,157513,157181,157180,157054,156886,155881,156040,162686,161248,160175,159223,158778,155706,161743,160891,160002,158803,158702,158033,157809,152746,149188,150821,162334,162332,162322,162084,162083,161990,161988,161933,161202,161201,161200,161150,161149,160589,160520,160213,159374,159058,158488,158448,158447,158446,157494,157320,157183,157182,157140,157138,157137,157075,157074,157073,157071,156694,156470,156469,156468,155927,155926,155925,155924,154691,154689,154688,152103,152556,32551,155560,155535,155274,163567,163568,157970,163565,163566,163827,163997,164290,164289,164291,157522,164231,164507,164460,164292,164813,164830,164831,156472,165748,165787,164232,166343,166041,166339,167152,167110,77734,167202,167190,167189,157139,161506,155792,167206,167191,167200,167205,168189,168080,168081,168313,155537,165754,163999,163998,159997,160895,168405,168406,168354,168780,168784,168901,168732,168992,169027,169537,168747,169437,168600,168612,161746,169084,155496,169925,170092,170091,170426,168744,169047,171939,169085,172249,172238,172265,168459,173114,173093,173514,173756,173927,173932,173957,173967,173973,173974,173992,174368,157981,175279,175378,77733,156471,175377,175606,175595,175602,175605,175603,163981,175604,175735,176032,176028,176041,176040,176031,176033,176037,176036,176304,176431,176512,159059,176430,167203,176429,155931,177559,174980,176126,177690,177688,177689,176523,178190,178191,178192,178193,177138,173167,173100,173609,178158,174902,172299,169086,178302,178907,176129,176928,177251,175144,180829,180828,177332,180064,181782,181686,178170,184271,184272,180953,184916,184920,184918,177412,185173,185290,175824,185557,187157,181390,178698,181391) AND ur.satis_durumu=1 AND ur.marka_id in (5,256,578,254) AND (ur.bayi_id='0' or ur.bayi_id='4631') 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 (23787,27050,25469,26974,29846,30061,30800,31740,31894,32083,32192,33354,32133,34674,34667,30040,35050,49105,30815,29872,45968,48387,77480,45701,77732,49380,78426,78578,148452,34946,77736,22433,33270,25155,152903,152902,152895,155254,155570,155510,155509,150774,156887,161783,161779,159063,159060,160218,160175,163070,163069,162385,160894,160892,160572,159999,158829,157794,156693,155319,155318,154803,153537,149188,82145,35850,154141,162084,161200,160600,160589,160213,159058,157183,157182,157140,157137,156694,156470,155924,154688,152103,155560,163827,164290,157522,164396,164397,164507,166343,166339,167490,167205,168080,168081,166314,163999,163998,164701,168874,168732,168992,169027,169084,169925,170092,170091,167764,171939,169085,173093,173991,173992,174368,175378,175377,175595,175735,176032,176028,176031,159059,176430,178120,178122,178123,180829,180828,180690,180064,180542,182446,182447,185173,178121,173544,185167,185925,185164,185165,184117,183615,180830,171843,171844,171888,173717) AND ur.satis_durumu=1 AND ur.marka_id in (5,256,578,254) AND (ur.bayi_id='0' or ur.bayi_id='4631') 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 (23787,25154,25463,25497,28197,28728,27885,26140,25479,25469,25468,26974,29463,29845,29883,29859,49577,30647,30648,30747,30800,30883,30885,30886,30776,31894,31891,32083,32075,32073,32192,32524,32722,32749,33010,33011,33014,33099,33116,33354,34513,32991,32250,32133,34674,26970,32000,34667,33007,31215,35050,33660,32647,33659,29464,35577,29847,29886,29944,33661,35831,35825,44578,30815,26083,25484,48568,48561,48387,44950,49100,49376,77394,77480,49104,49101,49098,48999,48564,48565,45701,31210,77728,28951,78268,77729,24430,50793,28814,45069,79469,81272,81628,82100,82101,80010,82131,148024,78578,148227,148377,148605,150276,149011,148023,150794,32077,150335,30748,82144,77736,152644,151711,150563,80713,25155,30778,153628,149978,155508,158186,157933,156304,155692,155687,155570,155511,155510,155509,158779,155160,152135,151339,150303,150302,150301,81653,81627,31999,158817,156887,155512,159124,159468,159511,160348,29863,159063,159060,160094,153889,160175,162423,158378,19746,149188,163251,162084,162072,162069,161915,161914,161212,161200,160589,160213,160148,160027,159058,158222,157491,157183,157182,157140,157137,157072,156732,156694,156470,155924,154688,152103,152102,152458,148396,32173,23729,23727,155561,155560,154425,154399,150652,150453,149921,149578,148231,148230,82553,82552,82551,80993,77586,77392,77313,47844,32078,29866,163573,163827,160093,163959,164290,157522,164507,162058,164700,165224,165227,165229,165465,165469,165562,165619,166023,166030,166135,166136,166476,166482,162825,166022,166343,166831,166339,82132,152022,163250,164315,167850,167205,167208,168080,168081,168368,160092,163999,163998,168366,167989,77731,168834,168732,168992,169027,169033,49099,169363,153000,169084,169925,170092,170091,170865,171827,171939,168442,169087,172126,169085,172684,172340,172341,166402,173093,173354,173355,170984,173992,174144,174145,174233,174252,174322,174368,155569,175122,175123,175124,175125,175126,175378,175377,175595,175835,175735,176032,176028,176031,176312,176817,159059,176430,173085,178423,160149,178599,178613,178614,178617,178618,178619,178785,178789,178790,178906,179627,179628,179629,179759,179538,167741,180185,180661,180829,180828,180824,180064,180999,181156,182269,182267,182268,160598,183884,184135,184136,184137,184138,172095,185173,172496,185873,183587,178031) AND ur.satis_durumu=1 AND ur.marka_id in (5,256,578,254) AND (ur.bayi_id='0' or ur.bayi_id='4631') 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;-->