<--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 (48222,30027,30467,30469,30470,30471,30612,30611,30616,31135,35655,33187,35014,34961,34767,34766,34764,34750,34712,34709,34699,34643,34642,34503,34610,34200,34164,34096,33975,33969,33845,33839,33736,33716,33714,33701,33667,33602,33601,33600,33583,33582,33571,33542,33541,33233,33232,33231,33222,33199,33179,33176,33175,33059,33053,33051,33050,32829,32811,32781,32778,32489,32212,32066,31822,31793,31068,30329,30026,29950,31549,29908,29906,34755,34741,33840,33584,33581,32067,32065,32064,30206,35249,34740,34081,35457,35453,35507,35513,35458,34768,48802,48357,35296,50247,49621,49620,49619,48440,48918,48917,48349,48348,32694,35506,29943,48393,34748,34747,35459,30826,30003,29948,30023,35033,29907,30388,29933,29912,33668,33229,29914,35160,29904,31973,31446,33228,33796,34118,29925,30384,35500,33220,29922,33221,32812,33219,29903,33235,49704,48345,48344,49421,50174,49408,48916,48914,49611,45171,48350,49299,34116,35162,29916,47631,34251,30228,29917,33821,35508,29905,33236,33223,33226,33225,29930,33230,35298,31790,31792,33234,31979,49618,48346,49457,49461,49453,49460,50305,48398,48232,50312,47088,49224,49265,48803,48282,48915,34698,50400,50176,49223,48225,50437,49462,49459,49448,49456,48227,49231,47481,47245,48283,48228,48420,49232,47030,46009,45251,45268,45858,45915,50548,50549,48913,50543,48358,50420,50487,34954,44724,48855,48851,48343,49446,49536,48804,50402,50401,50532,32437,32710,50399,50311,50637,50642,50625,50778,50777,50759,50760,50765,49542,49538,50954,50785,50838,50955,48919,51053,51093,51091,51090,51007,50926,50938,50971,51092,50972,50787,50786,77136,44965,77291,77298,48314,77137,77252,73190,73218,73189,73188,77122,77618,49450,50941,49234,50939,77682,49458,77619,48923,49625,77634,35247,35248,73220,50950,50646,77626,49041,49305,49237,49235,50982,49233,49310,49552,77387,48352,50177,50175,49545,49534,49309,49302,77139,48854,46913,50636,50245,77299,49238,48925,48353,48351,48347,72194,77944,34713,34710,34117,33227,33224,77902,77903,77620,77870,50936,78027,49624,49229,73029,77271,77257,28131,77275,50752,77273,50745,73028,77276,77274,50748,50753,50754,50751,78159,49447,78156,78180,78172,49615,45618,49612,49670,46520,45998,78178,78179,49613,78173,78171,78289,78075,78383,73217,78274,78380,78381,78382,50246,77297,48327,78485,77145,78484,78625,77602,78624,78158,78438,78284,78285,78291,79060,77396,78834,78831,78830,78495,78494,49598,49676,79100,79200,78835,78288,79366,79368,79365,79364,79417,79551,79552,79414,79584,79582,79090,79583,79585,79470,79657,79747,79865,78175,78176,46061,80044,80047,80082,80078,80077,80126,80213,80212,80306,80307,80308,80309,80407,80418,46736,80310,80313,80311,79467,79468,80314,80526,80641,80640,80080,80079,80853,80854,80856,80857,80972,81003,81002,81008,81004,81090,81091,81007,50953,81268,81341,81006,81269,81589,80976,81665,81637,81801,81805,81873,81802,81804,81872,79752,81765,79659,81271,81342,81660,81879,81880,82001,80450,82000,81999,81005,82373,82371,80446,82372,82370,78341,82253,82407,82403,82512,82411,82410,82405,82404,82401,82530,82557,147862,82794,147930,147910,82466,147929,147859,147858,82471,147861,147860,147913,147965,147964,147912,147961,147962,147911,82408,147914,82467,82470,82469,82468,148173,148154,148155,148221,148222,148260,148276,82159,148216,148303,80639,81274,81273,148441,148318,148317,148431,148434,148430,148429,148427,148386,80445,148388,148432,148240,148223,148362,148364,148435,148439,148581,148363,148428,148375,148241,148627,82400,148256,148681,148724,148720,148726,148433,148734,148722,148727,148725,148721,148731,148735,148732,148730,148729,148728,148736,148733,82476,149182,149228,149230,149292,149291,149345,149648,149869,149870,150046,150306,149694,82409,150498,150499,150591,150609,150645,150760,147963,150856,150818,150751,150750,150889,150816,150597,150596,151035,82406,149185,151093,150595,151344,151483,151484,150905,151519,150906,150907,151736,151798,151092,151929,81803,152039,150858,152140,151928,152062,152006,152004,150658,149376,151492,151491,150394,150393,151191,150397,150757,150424,150422,81256,152222,152391,149183,150748,151310,152711,152894,152739,152618,152008,152985,152976,152975,152974,152027,152369,150855,152026,151959,151991,80444,150425,153056,153089,153105,153137,153138,151765,153257,153280,153321,153354,153254,150902,153207,153368,153402,153403,153373,153359,153360,153365,153029,153028,153027,153503,153483,153536,153635,153692,153728,153722,153737,153760,153806,153896,153962,153960,153953,153961,153873,153872,154096,154099,154117,154118,154085,154199,154198,154234,154371,154392,154521,153907,154589,154359,154696,154708,154707,154747,154746,154796,154797,154914,154913,154912,154948,154949,154950,154959,155073,155187,155202,154784,154291,155317,154337,155365,155380,155403,155457,155460,152973,154916,154697,155506,155548,155551,153922,155735,153920,155907,155919,156074,156072,155808,156218,156270,156426,156675,154775,156862,156834,155550,157422,157451,157533,157531,155780,156462,156427,156305,156069,152971,156934,157065,157135,156031,158120,158250,158270,158275,158118,156938,159045,158412,158271,154795,159180,157935,158519,156173,154327,150903,82096,150904,150598,150408,49614,149507,149872,50970,51105,147908,49518,48924,79466,80694,80977,147907,148447,148443,148444,154324,149369,77873,46559,151556,152368,152367,153480,154709,154253,152731,155174,153372,153508,154497,153455,153454,153421,150295,148446,149181,149961,158100,147909,147960,149576,49407,157656,150759,50744,49230,50746,50503,50750,50499,45976,77878,48359,49236,46609,77895,48922,77901,48921,152920,78622,48920,79355,48805,157427,50790,49449,148445,148387,154952,148385,154953,151048,155166,152003,148436,148437,151120,149962,152433,151796,152992,78181,78155,150297,150396,47979,78157,150307,149859,158086,150900,149633,155728,79553,151531,50981,79932,153989,155126,152984,153139,157742,153177,154463,148723,154242,154685,156849,153331,153456,153422,153332,153507,154898,153545,152567,153525,154783,155694,156319,154119,77896,153481,149370,155572,156119,155060,157287,50747,49695,72717,50934,158121,49040,79271,154963,153426,81026,81025,82793,50788,151347,153990,154621,153993,153281,154964,150420,149963,150886,156745,152351,152993,155165,155395,155394,154235,30328,33665,82505,27271,48807,155392,151121,155391,51104,150885,156120,157474,155059,155269,156995,157341,156746,155594,152729,153441,151530,155157,49463,148442,82515,150042,149371,153871,153987,158248,149589,151797,153988,151806,151795,152997,155541,78231,148682,149184,152007,153371,153370,153369,153361,153026,153958,153959,154314,157765,159699,159698,159697,151819,151958,151990,151611,152370,151987,152434,153103,153102,82135,153134,153742,156068,154326,150761,153482,153496,149231,153660,153659,155396,155699,150762,150887,149868,151122,153991,154989,148012,153090,149293,153133,149914,153723,32439,32069,159628,158888,156731,156935,160137,160239,155547,158019,160011,160458,157064,159201,159388,160606,160604,160601,160580,160579,160489,160448,160414,160399,160383,160349,160309,160208,160189,160154,160152,160091,159973,159407,159406,159405,159404,159284,159069,158925,158904,158879,158877,158820,152972,153743,154951,155004,155014,155285,155286,155287,156222,157092,157156,157429,158125,158589,158802,160371,160245,160244,160243,160242,160241,160237,160234,160030,160029,158182,158181,158115,158093,157473,155393,154335,154321,159821,159716,159533,159516,159515,158907,158691,158428,158418,158413,158409,158345,160298,157938,157712,157709,157708,156794,155434,154896,154888,153343,160661,160660,159178,160141,159976,158389,156905,157535,157534,157530,159105,158082,158080,159104,158124,158119,158849,160358,160834,159367,160453,160452,160451,160443,160442,160441,160439,160435,160433,160016,160010,160007,160006,160005,160004,159972,159652,159387,158821,158054,157741,156380,155549,160252,160251,154325,160238,160246,160028,160247,160088,160026,160207,159696,157059,158116,158386,158117,160031,156647,159074,160963,161180,158543,159391,161366,161260,161223,161447,161465,161443,161221,161531,161585,161605,161606,161667,161659,161749,161785,160370,161786,161133,161867,160240,161919,161897,161910,161850,161924,161925,156440,162186,162196,157939,162242,162241,162239,162237,162233,162230,162639,162236,162240,162235,162090,160434,163028,162852,162770,162358,162280,161751,161750,161161,160012,160432,160049,162086,163025,163157,163214,159742,158825,162695,163399,162891,161876,163472,163473,163562,163572,161182,163664,163666,163477,163665,163549,163550,163663,163563,163555,163965,163994,163995,158827,164110,164206,164278,164261,161220,159403,164267,164262,164275,164276,164260,164268,164353,164367,157532,161879,164514,164359,164616,161984,164665,159385,164615,164848,164850,164621,164420,165382,162225,165512,164288,164279,165724,165746,165747,165584,165851,161406,165812,165378,166069,166076,166156,165859,166121,165521,166441,164274,166490,166444,166488,158272,157710,166423,166437,165381,165376,163468,166415,164854,164852,164851,164825,164819,164656,164052,165377,166427,166426,164314,166414,164033,166428,163027,164658,164273,163925,165858,167914,167794,168314,168303,168237,167967,167966,167926,167889,167888,167853,167738,167737,167736,167735,167734,167733,167732,167731,167730,167729,167728,167727,167726,167725,167724,167722,167721,167720,167719,167714,167711,167710,167487,167075,166889,166888,166887,166886,166885,166884,166882,166881,166874,166491,166489,166430,166429,166424,165957,165519,165506,165501,165450,165449,165446,165445,165444,165434,165432,165431,165430,165428,165422,165417,165366,165365,165358,165350,165349,165348,165346,164914,164913,164855,164853,164847,164820,164655,164653,164649,164648,164272,164271,164270,164265,164264,163469,163164,163067,162234,162232,162231,161909,161823,161530,160155,166867,166890,165508,165505,165504,164821,164650,166891,164277,166901,156215,164824,168325,168229,168318,168317,168316,168315,168268,168228,158826,158828,159278,160440,161063,161064,161160,162091,162092,162093,162382,162520,162790,162881,163065,163249,162882,163208,163308,163419,164036,164037,164038,164039,164040,164042,164122,164123,164124,164139,163822,164324,164339,164342,164344,164346,164406,164417,164510,164511,164512,164513,164515,164516,164517,164609,164664,164668,164669,164672,164674,164675,164793,164906,165807,165854,165856,165857,166119,166120,166155,166848,167533,167844,164345,162125,163420,162521,163422,168460,168461,168462,168565,168375,168905,168904,168922,168920,168906,166291,165956,165955,165518,165426,165425,165424,165421,165420,165143,165144,165191,165192,165193,165194,165208,165209,165210,165211,165212,165213,165214,165347,165418,165419,167716,167717,167718,168126,168121,166846,165448,165447,165443,165363,160249,169226,169410,169408,169406,169358,169294,165433,164583,169409,169692,169868,170075,166869,170076,170077,170095,170096,170100,170086,170268,170349,170351,170352,170365,162183,170401,170399,170398,167923,165364,167739,170455,170390,170866,166290,165000,165012,165042,166289,165013,165877,165009,165002,165001,165010,168495,166654,167916,165011,171604,168403,168404,171652,171651,171653,171654,171655,170023,172011,170652,172012,172072,172120,172144,172145,172146,172147,172220,170085,172222,172223,172224,172068,172232,172207,170756,172506,172569,172440,172441,170084,172542,170105,172899,171663,171669,172903,170454,170453,170434,172865,172221,173102,173219,172866,172867,172868,165359,172864,172271,164617,164620,165195,172270,172269,172274,172272,172275,161868,172541,171657,172917,172901,173370,173347,173369,173566,173364,173567,168402,170755,170388,170653,173673,173674,173340,173350,173346,171678,173643,171681,171664,173343,173647,173648,173563,173649,173348,174292,174305,174304,174299,174330,174294,174295,174310,174298,174311,174274,174059,174296,174061,174060,172273,174308,173650,174104,174199,174195,174196,173564,173372,173352,173561,174056,174077,173377,174076,174058,173578,174057,173351,173373,173210,173375,173379,174276,173367,173374,174079,174080,174055,173371,170079,173565,174329,174300,171826,171934,168921,171825,175129,175130,170094,175235,174054,172840,175856,175860,175475,173341,175567,174512,174614,174695,174513,173560,175933,174335,176189,176246,173677,176029,176305,175594,176583,176729,176752,175568,171660,174193,176818,176652,176655,176654,173559,172268,172863,176819,171661,176675,176812,174275,176683,176685,177358,176987,176990,176991,176988,177417,177057,173363,177603,165427,160607,177670,174293,170400,176821,176534,177793,176820,175510,176684,177543,172293,172439,174066,177544,176813,177174,178112,178390,178356,178481,175580,168122,168078,178382,177480,178522,174194,176034,173368,173376,173362,173342,171682,174517,178568,170397,178976,176550,174190,179407,179387,179595,179536,174788,169809,178521,178523,168267,178454,178453,179392,179386,179400,179922,179923,179921,179657,179926,180015,174297,177660,180017,180018,180019,179851,180837,179853,180673,180526,180674,180028,180029,179672,179850,180139,180033,179852,179671,179849,179840,180663,172902,175679,180984,179848,180983,179847,179842,179673,179675,179839,179838,180985,179841,180138,179674,180032,178083,181396,181068,181067,181221,181072,181220,181071,181070,181222,180539,181069,181586,180135,180536,181445,180911,181444,181066,181302,181300,181303,181308,181301,181307,174053,181297,181306,180533,180534,181690,181804,177024,181745,182090,182089,181305,182092,182191,181223,182091,181691,180662,180537,179390,176195,179460,179889,179391,181290,180016,179924,178204,179457,179920,180535,181299,181065,182587,182588,182580,183121,176564,182824,183345,183094,183179,183344,183341,181304,183604,183346,184236,184237,184230,183666,183653,183610,183649,183606,183665,183652,184231,184433,184434,183662,184715,184719,184716,184426,184721,184722,184724,184723,184726,182515,183663,185058,184718,185180,179484,183797,184717,182853,177237,185714,183802,184407,183804,174734,182490,183801,186401,181443,175924,179891,184294,184849,187249) AND ur.satis_durumu=1 AND ur.marka_id in (5,52,432,1381604,21628) AND ur.temin_edilemiyor = 0 and ur.stok > 0 AND (ur.bayi_id='0' or ur.bayi_id='62646') JOIN urun_kategorileri uk ON ur.id = uk.urun_id and uk.kategori_id = 1798 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 (156031,158250,158118,157287,158121,153492,160239,160248,160448,160189,160154,160153,159406,159405,159404,159069,158925,158878,160371,160245,160244,160243,160242,160241,160237,160234,160030,160029,159108,159107,159106,158115,159533,159515,158907,158691,158413,158409,158345,157709,158083,158082,158081,158080,158077,158076,159104,158849,160453,160452,160010,160006,159652,160887,160251,160238,160246,160028,160247,160088,158116,158386,158117,160031,159074,159391,161749,161785,160370,160240,161919,161910,161925,161935,162196,157939,162639,162236,162852,161161,162695,163399,163665,163965,163963,164206,164260,164268,164616,164665,164615,164848,164850,164621,164279,165812,166069,166441,157710,166883,166415,164854,164852,164851,164825,164819,164656,164052,166427,166414,166428,164658,164273,163925,168303,168237,167967,167966,167926,167738,167731,167730,167727,167725,167722,167720,167719,166887,166885,166884,166489,166424,165519,165450,165449,165446,165445,165444,165434,165430,165422,165417,165366,165365,165358,165350,165349,165348,165346,164914,164913,164855,164853,164847,164820,164655,164653,164649,164648,164281,163961,163469,162234,162231,164821,164650,166891,164277,164824,168318,168316,168315,168228,160009,162093,164247,165956,165955,165518,165426,165425,165424,165421,165420,165143,165144,165191,165193,165194,165208,165209,165210,165212,165213,165214,165418,165419,167716,167717,167718,168126,168121,166846,165448,165447,165443,165363,160249,169226,169410,169358,169294,164583,169692,165520,170075,166869,170076,170077,170095,170096,170100,170086,164205,170365,170401,170399,165364,167739,170390,170866,166289,165013,165877,165009,165010,167916,171604,168403,168404,171652,171651,171653,171654,171655,170023,170652,172072,170085,172222,172068,172232,170756,172506,172569,172442,172441,172542,172865,172221,173102,173219,172867,164617,164620,172275,161868,171657,172917,168402,170755,170388,173673,173674,173340,171678,173643,171681,171664,173343,173647,173648,173649,173348,174330,174294,174295,174310,174274,174059,172276,174308,173650,174104,174199,174056,173377,174058,173578,174057,174083,173210,174329,174300,175130,170094,175235,175856,175860,175475,174512,176189,176583,176729,174193,176652,176655,176654,172268,171661,176675,176812,174275,176683,176685,176990,176991,176988,177057,177603,165427,177670,170400,176821,176820,175510,176684,174515,174516,176813,177174,178112,174082,172070,168122,168078,178522,171682,174517,170397,178976,174788,178521,178523,179922,179923,179657,180015,178088,174297,177660,180017,180018,180019,179853,180029,179852,175679,179675,180138,181068,181067,181221,181220,181222,180539,181066,181302,181300,181303,181308,181301,181307,174053,181297,180533,180534,181690,181223,181691,179460,179889,179391,181290,180016,179924,178204,181732,179457,179920,182587,183121,176564,183344,183341,183606,184231,184434,184716,184718,185180,182853,184407,158888,164367,161984,165512,167710,167487,168325,172220,172899,171663,171669,172903,172866,172868,172272,172901,173347,173369,173364,173563,174305,174304,174299,174298,174296,174061,174060,172273,174195,174196,173352,174077,174076,174276,173367,174079,174080,174055,174054,172840,175567,175511,174335,175568,171660,172863,176819,176987,173363,177793,178382,174194,178568,174190,179387,169809,179392,179386,180837,179840,172902,179674,181396,180536,181445,181306,177024,181745,181749,181305,182191,182580,183604,183346,184236,184237,184426,184721,184726,182515,183797,184717,177237,184849) AND ur.satis_durumu=1 AND ur.marka_id in (5,52,432,1381604,21628) AND ur.temin_edilemiyor = 0 and ur.stok > 0 AND (ur.bayi_id='0' or ur.bayi_id='62646') JOIN urun_kategorileri uk ON ur.id = uk.urun_id and uk.kategori_id = 1798 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;-->