<--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 (155520,155521,155522,156956,156957,156958,156959,156974,156962,156961,156960,161294,163840,163841,163842,163843,164019,164020,164021,164022,164170,164523,164642,163135,164525,168140,168141,168143,168139,168138,168137,168344,168346,168345,163165,168889,168891,168890,168347,169484,169486,169485,172938,158407,174008,167373,174251,175083,178966,178967,178968,178969,178970,179417,179820,180128,185141,185139,185137,185138) AND ur.satis_durumu=1 AND ur.marka_id in (60,124) AND (ur.bayi_id='0' or ur.bayi_id='57890') JOIN urun_kategorileri uk ON ur.id = uk.urun_id and uk.kategori_id = 2162 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 (30493,33139,33141,50557,50558,33849,77389,45259,77685,79036,80979,81561,81559,81558,81106,81552,150470,151385,151386,151387,153348,155522,155911,155917,156958,156961,156947,158855,161456,163839,163842,164021,168140,168138,163165,169486,174008,174251,175083,179417,185138,186278,186762,186758,186749,186754,186766) AND ur.satis_durumu=1 AND ur.marka_id in (60,124) AND (ur.bayi_id='0' or ur.bayi_id='57890') JOIN urun_kategorileri uk ON ur.id = uk.urun_id and uk.kategori_id = 2162 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;-->