SELECT a.*,b.name_en l_en,b.name_cn_s l_cn,t1.name_en h_en,t1.name_cn h_cn,t2.name_en a_en,t2.name_cn a_cn
         FROM football_vs a  
         LEFT JOIN football_league b ON a.league_id=b.league_id 
         LEFT JOIN football_team t1 ON t1.team_id=a.home_id 
         LEFT JOIN football_team t2 ON t2.team_id=a.away_id 
         WHERE a.vs_code='a5szh36' LIMIT 1<br>Unknown column 't1.name_en' in 'field list'