SELECT B.NAME_EN, B.SURNAME_EN, B.NICKNAME_EN, A.ID, A.MINUTE, A.MINUTE_ADD,
        A.TYPE, A.CLUB, A.CLUB_AUTO, B.COUNTRY_PLAY1, A.PLAYER, A.MATCH, A.NONAME_EN
        FROM TGOALS A 
        LEFT JOIN TPLAYER B ON (A.PLAYER=B.ID)
        WHERE A.MATCH IN () ORDER BY A.MATCH, A.MINUTE+A.MINUTE_ADD