Select c.name as charge_name, d.name as court_name, c.location, d.code as court_code, c.no, c.time from aceauction.ac_charge c, aceauction.ac_court d where c.court_code = d.code and c.method <> '기간입찰' and c.fixed_date = '2031-02-04' group by c.no order by d.ord