<--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 (14452,28925,26966,26004,18103,16209,3941,13404,46575,32297,32299,32298,34576,35834,30674,48573,47721,47526,47212,46859,46739,49387,45926,45471,45728,58147,79746,78611,78598,47787,78276,30692,22639,22489,20079,19290,19287,50406,50678,31085,12240,26134,25255,29986,3964,3946,50172,31786,50173,15778,25933,34881,49636,15777,15775,18257,27269,48872,30635,48871,50677,35856,49108,18695,13467,50703,50702,28294,80130,77884,80414,81763,80663,46686,49109,149794,149795,149889,149888,149886,149885,79742,150061,149953,149952,149954,152494,10525,151393,152999,152147,153927,153904,153901,156179,150387,157126,157413,158771,158770,156314,159081,152646,152148,46478,156645,156646,152647,159918,159917,159481,78876,160392,160391,160390,160389,160719,160733,160731,163048,162515,161518,165237,165238,165240,165383,165462,165893,165894,165907,166318,165016,166611,167077,167099,167100,167465,167523,167613,167825,150388,168291,168294,168300,168301,168302,168331,168332,168395,168396,168411,168422,168423,168424,168425,168507,168508,168532,152967,168884,169172,169499,169501,169697,169949,169950,170102,170103,170386,170412,170484,170736,170737,170738,170811,170812,170813,170814,168236,168234,168233,168231,171578,171579,171580,171755,171756,171806,171807,171828,171860,171861,171864,171865,171866,171881,171897,171898,171899,171900,171912,171954,172037,172089,172090,172091,172112,172113,172114,172115,172155,172156,172242,169414,172520,172521,172545,172546,172660,172408,172674,172861,172896,173120,173128,173129,173130,173148,173200,173201,173202,173306,173307,173308,173309,173310,173360,173409,173475,173480,173481,173583,173584,170777,170776,173678,173679,173735,173736,173737,174071,174072,174073,174248,174324,174325,174328,174352,174371,174372,174454,174455,174495,174497,170786,170785,170789,170788,170792,174526,174527,174714,174740,174769,169292,169291,174889,170790,170787,175056,175057,175058,175117,175236,175237,175364,175421,175450,175454,175386,175387,175399,175388,175550,175648,175778,175787,175818,175819,175827,175828,175831,175907,176005,176006,176113,176148,176273,176274,176275,176560,176561,176587,176646,176648,176863,177122,177256,177303,177304,177320,177327,177330,177421,177435,177505,177572,177573,177750,177902,177983,177984,177985,178077,178127,178128,178654,178656,178780,178818,178837,178838,178899,178905,178910,178911,178937,178938,178939,178980,179298,179315,179317,179410,179466,179467,179619,179625,179635,179725,179781,179782,179783,179784,179785,179786,179787,180004,180607,180614,180617,180619,180668,180805,180806,180807,180808,180809,180823,180101,180930,180931,180934,180935,180937,180942,180943,180945,180946,180965,181038,181039,181040,181041,181042,181113,181114,181115,181116,181117,181164,181273,181274,181275,181369,181633,181636,181637,181638,181639,181640,181651,181695,181701,181803,181833,182046,182047,182153,182155,182159,182296,182317,182416,182418,182444,182445,182554,182581,182691,182692,182791,182792,182793,182794,183127,183128,183130,183145,181758,183199,183361,183381,183382,183383,183384,183385,183392,183474,183525,183563,183758,183759,183760,183771,183772,183997,184066,184091,184182,184249,184250,184330,184332,180648,184591,184634,184685,184686,184697,184780,184847,184862,184884,184886,184887,184888,184956,184994,185044,185045,185063,185073,185085,185155,185280,185284,185286,183285,183284,183283,183282,185497,185501,185502,185552,185553,185687,185880,185881,186008,186168,186171,186385,186402,168232,170791,169394,168235,172409,186512,186513,186719,186720,186732,186785,187010,174167,174170,178270,182232,187130,187141,187471,187474,187478,187488,187739,187745) AND ur.marka_id in (5,821,1161800,1218) AND ur.SKU like 'OU%' AND ur.stok > 0 AND (ur.bayi_id='0' or ur.bayi_id='65249') JOIN urun_kategorileri uk ON ur.id = uk.urun_id and uk.kategori_id = 1817 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 (160392,160391,160390,160389,161518,165236,165237,165238,165239,165240,165462,165595,165614,165893,165894,165907,166318,166622,167077,167099,167100,167292,167465,167523,167613,167825,168291,168294,168300,168301,168302,168331,168332,168395,168396,168411,168422,168423,168424,168425,168507,168508,168532,168884,169172,169499,169501,169697,169949,169950,170102,170103,170386,170412,170484,170736,170737,170738,170811,170812,170813,170814,168234,168233,168231,171578,171579,171580,171755,171756,171806,171807,171828,171860,171861,171864,171865,171866,171881,171897,171898,171899,171900,171912,171954,172037,172089,172090,172091,172112,172113,172114,172115,172155,172156,172242,169414,172520,172521,172545,172546,172660,172674,172861,172896,173120,173128,173129,173130,173148,173200,173201,173202,173306,173307,173308,173309,173310,173360,173409,173475,173480,173481,173583,173584,170777,170776,173678,173679,173735,173736,173737,174071,174072,174073,174248,174324,174325,174328,174352,174371,174372,174454,174455,174495,174497,170786,170785,170789,170788,170792,174526,174527,174714,174740,174769,174889,170790,170787,175056,175057,175058,175117,175236,175237,175364,175421,175450,175454,175550,175648,175778,175787,175818,175819,175827,175828,175831,175907,176005,176006,176113,176148,176273,176274,176275,176444,176560,176561,176587,176646,176648,176863,176908,176966,176967,177122,177256,177303,177304,177320,177327,177330,177331,177421,177435,177505,177572,177573,177750,177902,177983,177984,177985,178077,178127,178128,178653,178654,178656,178780,178818,178837,178838,178899,178905,178910,178911,178936,178937,178938,178939,178980,179298,179315,179317,179410,179466,179467,179619,179625,179635,179725,179726,179781,179782,179783,179784,179785,179786,179787,179945,180004,180607,180614,180617,180619,180668,180805,180806,180807,180808,180809,180823,180930,180931,180934,180935,180937,180942,180943,180945,180946,180965,181038,181039,181040,181041,181042,181113,181114,181115,181116,181117,181164,181273,181274,181275,181369,181371,181449,181633,181634,181635,181636,181637,181638,181639,181640,181651,181695,181701,181705,181707,181803,181833,182046,182047,182153,182155,182159,182296,182317,182416,182418,182444,182445,182554,182581,182691,182692,182791,182792,182793,182794,183127,183128,183130,183145,183199,183361,183381,183382,183383,183384,183385,183392,183474,183525,183563,183564,183758,183759,183760,183771,183772,183997,184066,184091,184182,184249,184330,184332,184591,184630,184634,184685,184686,184697,184774,184780,184847,184862,184886,184887,184888,184956,184994,185044,185045,185073,185085,185155,185280,185284,185286,185497,185501,185502,185552,185553,185687,185880,185881,186008,169385,172263,166770,152231,174166,169290,174172,174173,174174,174175,174169,174177,174176,186168,186171,186385,186719,186724,186785,186898,187010,178270,187130,187141,187202,187471,187474,187478,187485,187488,187739,187745,187792,187818) AND ur.marka_id in (5,821,1161800,1218) AND ur.SKU like 'OU%' AND ur.stok > 0 AND (ur.bayi_id='0' or ur.bayi_id='65249') JOIN urun_kategorileri uk ON ur.id = uk.urun_id and uk.kategori_id = 1817 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 (160392,160391,160390,160389,161518,165237,165238,165240,165462,165893,165894,165907,166318,167077,167099,167100,167465,167523,167613,167825,168291,168294,168300,168301,168302,168331,168332,168395,168396,168411,168422,168423,168424,168425,168507,168508,168532,168884,169172,169499,169501,169697,169949,169950,170102,170103,170386,170412,170484,170736,170737,170738,170811,170812,170813,170814,168234,168233,168231,171578,171579,171580,171755,171756,171806,171807,171828,171860,171861,171864,171865,171866,171881,171897,171898,171899,171900,171905,171912,171954,172037,172089,172090,172091,172112,172113,172114,172115,172155,172156,172242,169414,172520,172521,172545,172546,172660,172674,172861,172896,173120,173128,173129,173130,173148,173200,173201,173202,173306,173307,173308,173309,173310,173360,173409,173475,173480,173481,173583,173584,170777,170776,173678,173679,173735,173736,173737,174071,174072,174073,174248,174324,174325,174328,174352,174371,174372,174454,174455,174495,174497,170786,170785,170789,170788,170792,174526,174527,174714,174740,174769,174889,170790,170787,175056,175057,175058,175117,175236,175237,175364,175421,175450,175454,175550,175648,175778,175787,175818,175819,175827,175828,175831,175907,176005,176006,176113,176148,176273,176274,176275,176560,176561,176587,176604,176646,176648,176863,177122,177256,177303,177304,177320,177327,177330,177421,177434,177435,177505,177572,177573,177750,177902,177983,177984,177985,178077,178127,178128,178654,178656,178780,178791,178818,178837,178838,178899,178905,178910,178911,178937,178938,178939,178940,178980,179298,179315,179317,179410,179466,179467,179619,179625,179635,179725,179781,179782,179783,179784,179785,179786,179787,180002,180003,180004,180114,180115,180116,180607,180614,180617,180619,180668,180805,180806,180807,180808,180809,180823,180930,180931,180934,180935,180937,180942,180943,180944,180945,180946,180965,181038,181039,181040,181041,181042,181113,181114,181115,181116,181117,181164,181273,181274,181275,181287,181369,181370,181455,181456,181594,181633,181636,181637,181638,181639,181640,181651,181695,181701,181774,181803,181833,182046,182047,182153,182155,182159,182160,182162,182283,182296,182317,182416,182418,182444,182445,182554,182581,182691,182692,182693,182790,182791,182792,182793,182794,183122,183127,183128,183130,183145,183199,183361,183381,183382,183383,183384,183385,183386,183387,183392,183474,183525,183563,183566,183758,183759,183760,183763,183771,183772,183997,184066,184091,184182,184249,184266,184330,184332,184590,184591,184592,184634,184685,184686,184697,184779,184780,184786,184847,184862,184886,184887,184888,184948,184956,184990,184991,184994,185044,185045,185073,185085,185086,185119,185155,185280,185284,185286,185299,185492,185497,185498,185499,185501,185502,185552,185553,185555,185687,185880,185881,185882,185895,186008,186013,186015,186143,186168,186171,186383,186385,186391,186719,186726,186785,187010,178270,187125,187130,187131,187141,187471,187474,187478,187488,187496,187497,187498,187739,187740,187741,187745,187746,187798,187802) AND ur.marka_id in (5,821,1161800,1218) AND ur.SKU like 'OU%' AND ur.stok > 0 AND (ur.bayi_id='0' or ur.bayi_id='65249') JOIN urun_kategorileri uk ON ur.id = uk.urun_id and uk.kategori_id = 1817 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;-->