<--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 (11607,22264,22818,22820,21052,24686,32141,32662,32663,32665,48388,48361,23002,50332,50699,50293,5004,11105,11430,11432,18941,14847,21050,12380,78448,160543,161472,48366,50675,79737,79736,148781,152816,153067,153063,153061,153060,153157,153637,154088,154090,154092,154091,154380,154381,154346,154525,154069,154926,154876,154586,155747,155873,157094,156874,157107,158175,158148,158144,158143,158142,158141,158140,157419,159028,158745,158929,159463,159790,159795,159796,159797,159798,159799,161708,159534,162172,162173,162174,159713,159712,159708,159705,162552,162789,164176,164508,164541,164540,163498,166062,166061,166481,166827,166825,166824,167182,167186,164175,167338,159285,159269,159271,170905,171811,171812,171813,171984,172096,172098,172103,172101,170884,170885,172647,172503,172648,170904,174007,177074,177072,177067,177064,177529,177530,179102,179103,181154,181153,181152,181151,172097,173154,173155,177068,161898,164197,164202,164465,164548,164549,165248,165249,165254,165255,166815,167196,167651,167652,167657,167658,168809,168810,168813,168897,169634,169631,169760,169270,170917,170933,170911,170910,170923,171757,172099,172800,173133,174004,174425,173132,174584,174574,174576,174581,174586,168812,176437,177084,177083,177078,177077,177527,164574,177847,174432,178960,178957,178956,178959,178961,179118,167188,181534,181902,181813,181814,181885,177846,176436,180651,184101,180652,178958,184125,184371,184372,187210,187223,187602,161899,164550,164551,164554,164555,165250,165251,165256,165257,167405,167407,167408,167406,167653,167654,167659,167660,169271,169273,169274,169272,168588,169632,169635,169636,170912,170924,170934,174003,174005,174422,174856,177087,177080,177081,177079,177002,174428,177000,174429,177003,177001,178962,178963,178964,178965,179112,179121,179797,179119,183034,183036,183013,183012,182243,182244,184103,184104,184665,184666,184664,184667,185641,184102,174426,177197,187215,187214,187213,187211,187336,187345,170918,177639) AND ur.satis_durumu=1 AND (ur.bayi_id='0' or ur.bayi_id='35034') 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 (174426) AND ur.satis_durumu=1 AND (ur.bayi_id='0' or ur.bayi_id='35034') 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;-->