SELECT id, tm_sts, tm_country, tm_long_country, tu_score, tu_to_par, tu_rank, tu_rank_code,tu_cuser
FROM team LEFT JOIN team_summary
ON id = tu_tm_id AND tm_mt_id = tu_mt_id AND tu_rd_id = ''
WHERE tm_mt_id = '' AND tm_type='WO'
ORDER BY tm_sts, tu_cdate DESC,tu_rank,tu_cuser