schedule = db.session.query(Schedule.schedule_turn_name).filter(Schedule.league_id == request.args.get('league_id'),Schedule.schedule_process ==2).group_by(Schedule.schedule_turn_name).order_by(func.max(Schedule.create_time).desc()).all()
sql = "select a.schedule_id,b.team_name,c.team_name from schedule a inner join" \
" team b on a.schedule_team_a=b.team_id inner join team c on a.schedule_team_b=c.team_id where league_id = %s and schedule_turn_name = '%s'" % (league_id,sc[0])