SELECT a.*,t1.name_en h_en,t2.name_en a_en
         FROM football_result a  
         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.league_id='1574' ORDER BY a.match_time DESC LIMIT 30<br>Unknown column 't1.name_en' in 'field list'