<--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 (3682,3514,3348,5959,23002,24205,26161,49596,26830,28405,28406,28708,28721,28787,28965,29658,29774,30202,30767,30899,32140,32052,32660,32662,32663,32664,32665,33135,30008,34212,35352,35795,35812,48959,48392,48390,48388,48369,49333,48368,48367,48366,48363,48362,48361,33372,33369,44725,44726,49334,45486,49705,50318,50332,50435,50433,50431,50430,50429,50428,50425,50436,48955,44538,50659,49605,49544,50675,50664,77180,77179,77649,77648,77650,77646,77647,77651,77988,52634,30333,79737,78623,78606,78953,79549,79547,79543,78951,79528,79527,78954,79495,78955,77687,52641,77686,52556,78259,35796,34598,34596,52912,33379,50629,50432,52516,78198,50313,78197,49543,50293,79736,52517,48389,33381,33363,33378,33360,33358,35811,32661,31915,28912,79735,30625,33359,29681,5952,3706,78879,5004,50314,5954,78195,11429,11430,79734,14342,78952,29659,33362,33356,79733,33357,23074,26157,79732,22019,23868,18941,26163,78950,79429,79731,47653,80005,48365,79427,50661,52910,33365,48364,33183,78196,50507,52521,81562,81563,81584,78081,30367,49329,49323,148197,148196,148272,148274,148278,148277,82300,148281,148594,148782,148781,148780,148779,148778,148777,148775,148774,148773,148776,148787,148788,148789,148790,148792,148793,148796,148795,148791,79354,81889,82349,148233,148660,82095,148232,45338,81751,82350,33136,77924,148593,148658,50315,148273,49540,148659,23984,77689,79529,48285,30337,14847,22036,77386,49539,21050,148794,149351,149348,78880,149799,149801,148980,150910,151156,78194,151805,152064,152063,152164,152163,149858,78883,78885,78886,78884,150776,150781,150911,150777,151482,151267,150778,150912,150784,150785,150767,150782,150780,150914,78448,150787,151727,151728,151725,150636,151729,150789,151724,150913,150790,151726,152810,152811,152816,152817,152812,153024,153023,153022,153021,153020,153019,153018,153017,153016,153067,153063,153062,153061,153060,77645,153157,150766,153571,153573,153648,153649,153650,153637,154067,154088,154090,154089,154093,154087,154092,154091,154068,154070,153622,154377,154378,154379,154380,154381,154544,48391,153672,154345,154346,154525,154069,154818,154819,154820,154934,154926,154876,154586,155017,155018,155163,155164,154086,155745,155748,155747,155746,155788,154550,154549,154548,154547,156109,156111,153242,155076,155873,155872,155871,155870,155869,154308,52636,49283,156897,157062,157108,157094,156747,156874,157107,157697,158175,158178,158177,158176,158174,158173,158149,158148,158147,158146,158145,158144,158143,158142,158141,158140,158139,158134,158074,158073,158072,158071,158069,158068,52736,158135,157419,78887,159042,159041,159025,159028,159029,158745,158746,158781,158780,158783,154923,159229,158928,158927,158926,158923,158922,158921,158744,157983,159461,159459,159463,159676,159675,159674,155075,153741,159823,159824,159826,159790,159791,159792,159794,159795,159796,159797,159798,159799,159800,159801,159802,159803,159804,159806,159807,159808,159787,160543,160630,161293,161470,161471,161487,161513,161708,161619,161622,161621,161620,161618,159534,161898,161899,150779,162172,162173,162174,162304,152813,152814,162381,152815,149800,159713,159711,159712,159710,159709,159708,159705,159704,159703,162540,162541,162543,162545,162552,162622,162624,162679,162678,162675,162623,162789,163204,163352,163347,162544,162177,163628,152645,163634,164106,164105,164101,164174,164176,164197,164202,79415,164508,164543,164544,164545,164548,164549,164550,164551,164554,164555,164541,164540,164181,165453,163498,164390,165246,165247,165248,165249,165250,165251,165252,165254,165255,165256,165257,166062,166061,166091,166268,166298,164547,166481,166828,166827,166825,166824,166823,166822,166821,166260,166259,166258,166252,166817,167649,167650,167651,167652,167653,167654,167657,167656,167659,167660,167658,167186,166442,161971,166797,166251,164175,169073,168588,166826,169628,169634,169631,169632,169635,169636,169629,169633,166253,167337,167338,170494,170495,170844,170884,148275,170492,174568,174574,174575,174576,174580,174581,177086,177084,177087,177083,177080,177082,177074,177081,177076,177079,177072,177071,177067,177066,177065,177070,177064,177063,177078,177077,177075,177196,179102,179099,179109,179103,179101,179112,179100,179121,179119,179118,179114,167655,183033,183034,183035,183036,182247,50319,184102,177068,177197,30989,49327,49325,49606,44978,49607,78086,78958,78960,78878,78199,78959,78956,49277,78957,79636,77918,48002,77917,164465,164573,166798,166803,166804,166816,166815,167194,167195,167204,167180,167182,167187,167196,167198,167199,167401,167405,167407,167408,167402,167403,167406,167181,168807,168808,168809,168810,168811,168813,168814,168817,168818,168892,169269,169271,169273,169274,169272,169278,169275,169277,169279,169760,169270,170933,159285,157273,159271,170908,170905,170912,170911,170913,170910,170909,170920,170919,170918,170924,170923,170922,170921,171757,171984,172096,172098,172103,172099,172100,172101,164104,170885,172647,172646,159270,159265,172502,172503,172648,170934,170915,170914,170907,170904,172798,172800,172759,172758,172762,172760,173500,173696,173684,173685,173686,173687,174003,174004,174005,174006,174007,172102,174423,174422,174564,174856,174855,168812,176996,176992,176994,176998,164574,177635,177636,177637,177639,177844,177845,177847,177002,177638,174427,174428,177000,174431,174430,170906,174432,176999,177634,174429,176995,177003,177001,178306,178474,178507,178952,178953,178960,178955,178959,178961,178962,178963,178964,178965,178954,179802,179797,179804,179803,181152,181151,172097,167188,167404,172763,181811,181813,181808,182241,181885,181810,176997,177853,177846,168815,183013,183012,183011,184101,182243,182244,178958,170925,173154,173156,173155,173157,170493,183332,179798,184103,184125,184104,184665,184666,184664,184667,176993,184371,184372,185454,185641,183712,174426) AND ur.satis_durumu=1 AND ur.marka_id in (5,821,432,1381604,388) 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 = 1750 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 (22826,30494,33700,33699,33696,35352,48368,48367,34212,33372,33369,30989,23802,23708,47109,50517,50675,50664,77646,77647,77651,52634,30333,79495,52912,48365,52910,30367,82349,148660,153063,153062,153061,153650,154087,154092,154091,154820,153242,155870,157697,158178,158177,158176,158174,158147,158146,158145,158144,158143,158139,158130,158075,158135,157419,159044,159042,158780,159229,158929,158928,158927,158926,157983,159461,159459,159796,159798,159801,161165,161619,161621,161898,161899,162542,162550,163352,164105,164197,164202,164186,164201,164465,164545,164555,165049,164390,165247,165249,165251,165255,165257,166809,166828,166823,166817,167194,167195,167204,167182,167187,167196,167198,167199,167401,167405,167402,167403,167406,167657,167656,167659,167660,167658,167186,168807,168808,168809,168810,168811,168895,168892,169130,169271,169273,169278,169275,169277,169279,169270,166253,167337,167338,170494,170495,170844,170908,170912,170911,170913,170920,170919,170918,170921,172103,172101,159265,172502,172503,172648,170915,170914,170904,172758,172762,172760,173133,173500,174001,174003,174004,174005,174425,174423,174422,174564,174575,174576,174580,174581,174585,174586,174856,177084,177087,177083,177082,177074,177072,177071,177070,177059,176996,176992,176994,177635,177636,177637,177639,177851,177847,177002,177638,174427,174428,177000,174431,174430,178306,178474,178507,178953,178960,178955,178957,178961,178964,178965,179103,179100,179797,179803,179114,172097,167188,167404,181532,181534,181903,181811,181814,182241,181885,177853,176436,167655,183036,183011,184101,180652,173156,180650,179798,184103,184125,184665,184666,176993,183225,185454,184102,177197,187214,187213,187212,187223,187796) AND ur.satis_durumu=1 AND ur.marka_id in (5,821,432,1381604,388) 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 = 1750 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;-->