<--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 (22824,22825,24205,26161,28787,29774,32819,33698,33697,33695,49596,35812,48392,48369,48366,48363,44725,45486,50318,77179,77649,77648,77650,78086,46018,79737,78958,79528,78960,78201,78199,78959,77687,49543,79736,33363,35811,79735,33359,78957,79734,33362,79733,79732,50661,33365,48364,81562,81563,148197,148272,148278,148594,148782,148781,148780,148779,148778,148777,148774,148773,148787,148789,81889,148233,82095,148232,45338,77924,50315,148273,149799,152063,149858,78202,152811,152816,152817,152812,153067,153060,77645,153157,153573,153637,154071,154088,154090,154089,154093,154068,154070,153622,154377,154379,154381,48391,154345,154346,154525,154069,154934,154926,154586,155018,154550,154548,155873,155872,155869,154308,157108,157094,157107,78887,159025,158745,158746,154923,158744,159676,159675,159674,159792,159799,159802,159787,161487,161513,161708,162172,162173,162174,152815,149800,159712,159710,159705,159703,162540,162543,162622,162624,162789,152645,163634,164188,164195,164196,164508,164544,164548,164551,164541,166062,166827,166260,166258,168219,169269,166826,169635,169629,169633,169760,159269,157273,170910,170909,171757,171813,172099,172100,170885,172102,174855,177080,177081,177076,177066,177077,179102,179099,179112,181154,177068,186437,33700,33699,33696,34212,35352,48368,33372,77646,77647,52634,30333,79495,52912,48365,52910,30367,82349,148660,153063,153062,153061,153650,154087,154092,154091,154820,153242,155870,157697,158178,158177,158139,158135,157419,158780,159229,158929,158926,157983,159461,159796,159798,161619,161621,161898,161899,164105,164197,164202,164186,164465,164545,164555,165247,165249,165251,165255,165257,166828,167194,167195,167204,167182,167187,167196,167198,167199,167405,167402,167403,167406,167657,167656,167659,167660,167658,167186,168807,168808,168809,168810,168811,169293,169271,169273,169278,169275,169277,169279,167337,167338,170494,170495,170912,170911,170913,170920,170919,170918,170921,172103,172101,170915,170914,170904,172758,172762,172760,174004,174005,174423,174422,174564,174580,174581,174856,177084,177087,177082,177074,177071,176996,176992,176994,177635,177636,177637,177639,177002,177638,174427,174428,177000,174431,174430,178306,178474,178507,179103,179100,179797,179803,179114,172097,167188,167404,182241,167655,183036,183011,184101,179798,184103,184125,184665,184666,176993,183225,185454,184102,187214,187213,187212,187336) AND ur.satis_durumu=1 AND ur.marka_id in (5,213,1163,1218) AND (ur.bayi_id='0' or ur.bayi_id='34823') 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 (48369,48367,77650,77647,79549,78955,77687,33363,79735,78879,48365,50661,48364,148274,148594,148780,148778,148789,148790,82349,148233,82095,148593,148659,79529,149799,149801,150910,149858,150914,152811,152812,153023,153020,153017,153062,77645,153573,153648,153649,153650,154087,154068,154377,154378,154379,153672,154345,154819,154820,154922,155164,154086,155738,155745,155748,155746,155788,154550,154549,155076,155872,155871,155870,155869,156897,156747,157697,158178,158177,158176,158174,158173,158139,158136,158072,158135,159044,159043,159042,159041,159029,158781,158780,158783,159229,158928,158927,158926,158923,158922,158921,158744,157983,159461,159459,155075,153741,159823,159791,159792,159794,159802,159804,159806,159808,159787,159165,159457,159164,159458,161165,161470,161471,161487,161513,161772,152813,152814,152815,149800,159711,159710,159709,159704,159703,162549,162550,162622,162624,162679,162623,163204,163352,162177,163628,152645,163634,164106,164105,164172,164173,164174,164188,165049,164181,165453,164390,166807,166808,166809,166828,166823,166822,166821,167180,167401,167181,168219,168220,168221,168223,161971,169293,166826,167337,157273,170908,172100,172228,164104,148275,172646,159270,159265,172502,170907,173696,174006,172102,174855,158162,177071,177066,177065,177070,177063,177058,177059,177196,177851,177844,177848,177849,170906,178306,178474,179099,179109,179101,179100,179796,173156,173157,186728,187075,187074,187057,186437,187796,187795) AND ur.satis_durumu=1 AND ur.marka_id in (5,213,1163,1218) AND (ur.bayi_id='0' or ur.bayi_id='34823') 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;-->