We are flying to Paris, and then taking the train to Bayonne, and from there a direct local train to SJPP.
You can find a €23 fare on the TGV at the SNCF site.
It may necessitate, as in our case, an overnight in Paris, but then that's not so bad! There are certainly worse predicaments.
We...