<--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 (25297,29027,26250,28966,28671,27658,27644,27643,27567,26249,26207,26216,25295,25294,25291,22502,22493,21571,20076,12290,11921,9887,3987,26393,32231,32842,33074,34832,21478,33433,33425,35871,49115,49117,49113,49111,48236,48180,48081,46071,45323,32097,49389,49388,47745,47300,45720,49530,46013,46603,46491,46351,46100,44957,49571,43933,50257,23941,77126,58492,78523,58998,48237,30672,30628,29936,28967,25721,25260,22660,22478,26633,18914,28972,12243,50689,10208,10185,30761,50688,32406,50687,50686,26251,50685,50683,10217,34136,31039,31037,33002,30634,33274,30629,29548,29545,15771,78853,50706,50705,50704,34952,78287,50707,48253,48254,48582,49118,58699,50858,78213,12690,25293,25735,21572,10975,26003,78018,25730,10977,34583,34575,77310,34574,28989,29363,51100,51097,49116,29987,49637,46631,47094,29365,26628,29364,49114,28293,25739,77127,78093,31038,80038,32952,32974,80132,80135,80395,25740,30627,45544,49120,25061,81608,26865,25292,32451,148150,49492,149473,149887,149955,150584,27565,46321,49569,153101,78803,153898,154666,28204,155179,155176,35867,155360,155724,155952,156194,156799,157082,157086,157406,157405,157408,157415,157396,157838,157837,157836,159161,159126,159228,80160,34578,148753,148752,155779,148751,157102,150892,148822,148754,159125,157802,159913,159916,159912,159394,29362,49638,153849,160325,159636,154892,148479,152873,78015,157799,152302,158605,158603,153144,151203,153833,154652,154650,154630,153749,154095,157407,152350,152349,150070,151503,152781,46629,155235,151552,154492,157322,152234,152233,155784,155951,155950,158623,159914,159915,161431,161430,161290,162123,161668,163062,163060,163058,163052,163240,163479,163599,162764,155716,165232,165235,165411,165018,165017,160386,165559,165560,165484,165353,165342,165344,165343,165788,165892,165895,166057,166733,166710,166920,167066,167098,167322,167324,167524,167525,167536,167537,167589,167590,167614,167648,167819,167824,167832,167861,167862,167958,167959,168148,168207,168208,168295,168296,168297,168298,168299,168334,168335,168407,168409,168410,168499,168518,168530,168531,168550,168559,161417,168664,168669,168670,168673,168679,168697,168795,168796,168797,168798,168799,168800,168862,168863,168864,168924,168925,168926,168927,168928,168929,168930,168931,168932,168933,168934,168959,169048,169158,169282,169361,169368,169372,169374,169376,169377,169393,169463,169645,169647,169649,169698,169700,169946,169947,151297,151299,151296,151295,151298,151303,151301,151302,170384,170427,170450,170470,170740,170741,170742,170743,169068,170816,170817,170818,170819,170820,170845,170868,170385,171586,171587,171588,171589,171640,171753,171709,171801,171802,171803,171804,171895,171896,171916,171917,171918,171972,171977,171978,172066,172057,172154,172294,172295,172446,172512,172514,172515,172516,172596,172599,172659,172755,172860,172886,172887,172888,172892,172893,173003,173005,173007,173008,173009,173010,173083,173112,173122,173123,173180,173181,173196,173197,173198,173199,173229,173317,173319,173320,173387,173388,173407,173408,173471,173472,173473,173474,173478,173479,173551,173552,173582,173600,173601,173619,173669,173699,173712,173761,173803,173804,173858,173859,173874,173875,174069,173894,174182,174183,174245,174246,174289,174290,174369,174452,174453,174460,174461,174493,174494,174498,174618,174619,174712,174713,174888,174890,174891,174964,175005,175006,175055,175178,175179,175180,175238,175239,175240,175267,175268,175271,175365,175452,175400,175547,175713,175777,175413,175409,175407,175403,175401,175908,175919,175921,176007,176008,166853,176062,176168,176314,176315,176316,176317,176322,176323,175938,176361,176362,176393,176470,176488,176489,176490,176559,176588,176589,176647,176686,176687,176690,176726,176784,176897,176898,79484,176924,176940,177099,177100,177014,177123,177129,177131,177132,177133,177015,177141,177142,177143,177153,176964,177215,177255,177264,177297,177298,177299,177300,177301,177302,177328,177349,177350,177366,177567,177574,177575,177651,177652,30760,177491,175903,177706,177707,177745,177746,177747,177484,177898,167905,177940,178130,178131,178179,178417,178410,178409,167239,177871,178640,178651,178652,178683,178695,178781,178782,178904,178909,178932,178933,178934,179073,179075,179077,179186,179188,179616,179617,179618,179777,179779,180156,180613,180667,180669,180792,180803,180804,180352,180080,180076,180078,180855,180079,180967,180971,180972,180973,181005,180954,181043,181044,181118,181119,181120,181121,180063,181264,181265,181266,181267,181270,181271,181372,181373,181374,181375,181376,181412,181421,181422,181437,181438,181454,181457,181458,181595,181424,181425,181427,181697,181699,181772,173496,181602,182260,182314,182114,182115,182441,182469,182695,182752,182957,182976,183147,183393,183476,183565,183567,183583,183971,183983,184062,184065,184173,184251,184252,184300,184334,184364,184536,184644,184669,184660,184703,184891,184995,185003,185101,185213,185214,185282,185023,185574,185575,185576,185703,185750,179535,185699,185896,185897,185942,186194,186195,186196,151304,150137,159469,161409,186502,186503,186504,186505,186507,186508,186510,186514,186902,186932,186991,186992,186993,187033,187201,187507,183612,187670,187731,10565,4002,49509,17681,78851,31214,17704,34149,149883,149878,152986,154568,155178,155946,157084,79482,155935,81093,151005,156256,161432,162854,162857,162856,162858,163064,164845,166383,166715,166709,166010,168589,169067,151294,169071,173125,173497,174323,174367,175411,175405,177155,177187,180077,181426,186506,186509,186515) AND ur.satis_durumu=1 AND ur.marka_id in (5,67,432,1218,410) AND (ur.bayi_id='0' or ur.bayi_id='63975') JOIN urun_kategorileri uk ON ur.id = uk.urun_id and uk.kategori_id = 1819 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 (29027,27658,27644,27643,27567,26207,26216,25295,25294,25291,22502,22493,21571,13601,11921,10565,4001,3987,26393,32231,32234,32310,32312,32313,32314,32315,32317,32842,32841,34832,13598,21478,33433,33425,35871,49115,49112,49117,49113,49111,46071,45323,49389,49388,47745,47300,45720,49530,46013,46603,46491,46351,46100,46089,46088,50257,77126,58492,58998,4002,49509,30672,30628,28967,25720,26629,22660,26632,18914,26868,12243,50689,10208,10185,50688,50687,50686,50685,31039,31037,33002,30634,30633,30629,15771,78853,50706,50705,50704,34952,78287,50707,49118,58699,49119,78213,12690,25293,25735,21572,10975,26003,78018,25730,34583,46751,34575,34574,29363,51100,51097,49116,49637,47094,26628,29364,49114,28293,25739,77127,78093,31038,80038,78852,78851,80132,80135,25740,30627,45544,25061,26865,25292,148150,49492,58712,149473,149877,149880,149879,149878,149955,150584,27565,46321,49569,153036,78803,154568,154570,154569,155176,155724,155952,157091,157082,157086,157085,157408,157415,157396,157836,159161,80160,34578,148753,148752,155779,148751,157102,150892,148822,148754,29362,49638,153849,160325,153014,152302,158605,158603,153144,151203,153833,154652,154650,153749,154095,152350,152349,151503,152781,46629,151552,154492,152234,152233,155784,155951,155950,155949,158623,159914,159915,161290,161668,162855,162854,162856,163052,163240,163479,163599,165232,165235,165411,165018,165017,165559,165560,165343,165892,165895,166057,166732,166733,166756,166876,166710,166920,167066,167098,167322,167324,167524,167525,167526,167527,167536,167537,167589,167590,167614,167648,167824,167832,167860,167861,167862,167958,167959,167960,167994,168149,168150,168171,168172,168207,168208,168226,168295,168296,168297,168298,168299,168334,168427,168499,168505,168518,168530,168531,168559,168670,168671,168672,168673,168679,168697,168746,168795,168796,168799,168800,168862,168863,168924,168925,168926,168928,168929,168930,168932,168934,168959,169158,169306,169361,169374,169391,169392,169393,169645,169646,169946,170384,170427,170450,170740,170741,170742,170743,169068,169492,170816,170817,170818,170819,170820,169071,170845,170868,171586,171587,171588,171589,171640,171753,171709,171801,171879,171895,171896,171916,171918,171972,172066,172154,172294,172295,172515,172516,172599,172600,172659,172860,172892,172895,172929,173003,173005,173009,173122,173123,173196,173197,173198,173320,173387,173388,173471,173478,173551,173552,173600,173601,167903,173669,173699,173712,173761,173803,173858,173859,173875,174182,174183,174245,174246,174289,174290,174367,174369,174452,174498,174618,174619,174712,174713,174964,175006,175179,175238,175239,175240,175267,175268,175271,175365,175400,175623,175401,176062,176168,176314,176317,176362,176363,176393,176470,176489,176559,176588,176647,176690,176782,176897,176898,79484,176940,177123,177129,177131,177132,177133,177141,177153,177255,177264,177301,177302,177328,177366,177575,177652,177706,177746,177747,177748,167905,177940,178179,177871,178684,178695,178782,178932,178933,178934,178935,179075,179076,179186,179188,179618,179777,179778,179779,180005,180156,180613,180667,180669,180803,180080,180855,180967,180971,180972,180973,181005,181043,181044,181118,181119,181120,181121,181264,181266,181267,181268,181269,181270,181271,181372,181373,181374,181375,181376,181437,181438,181454,181457,181458,181595,181632,181697,181772,181773,173496,182260,182441,182695,182752,182957,183231,183393,183394,183470,183773,184062,184065,184180,184305,184364,184495,184534,184660,184770,184846,184857,184891,184995,185101,185156,185023,185750,185897,186194,186195,186196,186410,150137,159469,161409,187143,187201,183613,183612,187731) AND ur.satis_durumu=1 AND ur.marka_id in (5,67,432,1218,410) AND (ur.bayi_id='0' or ur.bayi_id='63975') JOIN urun_kategorileri uk ON ur.id = uk.urun_id and uk.kategori_id = 1819 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;-->