<--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 (157877,157077,155793,155570,154185,150774,149022,151735,156923,155614,157079,160889,161483,161783,161782,161781,161780,161779,162321,159060,157054,156886,155881,156040,162686,161249,161248,159368,155206,163070,163069,163068,162385,161743,160894,160891,160572,158829,158284,157809,157794,156914,156693,155552,155319,155318,154803,153537,153333,153295,152746,149188,35850,154141,162332,162084,161988,161933,161201,160600,160589,159374,159058,157494,157183,157182,157137,156694,156470,152556,32551,155535,152828,163565,163566,163827,164290,164291,157522,150238,164396,164397,164507,157521,160893,164813,156472,165787,166343,166041,166339,167152,77734,167490,167393,157139,167668,161506,155792,167205,168189,168080,168081,168313,163999,163998,168405,164701,168874,168902,168732,168992,169027,168747,169437,168600,168612,169084,169925,171843,171844,171888,171939,169085,172249,172265,168459,172940,173093,173957,173991,173992,173717,174368,175378,77733,156471,175377,175606,175595,175602,175605,175603,163981,175604,175735,176032,176028,176041,176040,172122,176031,176033,176037,176036,176431,172123,172125,176430,167203,176429,155931,177559,176126,177690,177688,177689,176523,178190,178191,178192,178193,173167,175977,178158,174902,169086,178302,176877,178907,177857,178701,177251,178120,178122,178123,180829,180828,177332,180064,180542,181780,181782,184271,184272,180953,182446,182447,184916,184920,184918,177412,182519,182520,185173,185557,185164,185165,183615,187157,187443,181390,178698,181391) AND ur.satis_durumu=1 AND ur.marka_id in (5,254) AND (ur.bayi_id='0' or ur.bayi_id='64191') JOIN urun_kategorileri uk ON ur.id = uk.urun_id and uk.kategori_id = 1810 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 (159060,156886,155881,161248,159368,162385,161743,160891,160572,159971,156693,155552,155319,155318,154911,154803,150082,154141,154038,162694,161201,157072,156470,155535,150453,164397,162737,164507,164797,164905,165784,166030,166135,166343,166339,167393,157139,167668,167804,167205,167208,168081,168480,168561,168560,168732,169514,150640,170089,170822,168544,172128,172135,173093,173991,173717,174368,174752,175835,175735,176032,176040,176433,167203,175861,178137,175977,169086,178785,178789,178790,179957,180829,180828,180999,180953,177956,183588,168557,182846,187114,178031,175862,185482) AND ur.satis_durumu=1 AND ur.marka_id in (5,254) AND (ur.bayi_id='0' or ur.bayi_id='64191') JOIN urun_kategorileri uk ON ur.id = uk.urun_id and uk.kategori_id = 1810 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 (159063,159060,156886,155881,161248,159368,162385,161743,160892,160891,160572,156693,155552,155319,155318,154803,152751,154141,162083,161201,158448,157320,157140,157075,157074,157073,156470,155926,155924,155535,164397,164507,164830,164831,166343,166339,167393,157139,167668,167205,168081,155537,168732,170090,170092,170091,170426,169047,173093,173991,173717,174368,175735,176032,176040,159059,167203,168981,175977,172299,169086,180829,180828,180953,183590) AND ur.satis_durumu=1 AND ur.marka_id in (5,254) AND (ur.bayi_id='0' or ur.bayi_id='64191') JOIN urun_kategorileri uk ON ur.id = uk.urun_id and uk.kategori_id = 1810 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;-->