select Nom as nom, concat(Adr1,' ',Adr2,' ',Adr3) as adr, Adr4 as adr1, Adr5 as adr2, Codpost as codpost, Ville1 as ville, Mail as mail, Tel as tel, Fax as fax, concat(A13,' ',A14,' ',A15) as p, President as president, TelPresident as telpresident, Lat as lat, `Long` as `long`, Web as web, Comment as comment from `bridgeresultats_hurepoix`.`hurepoix_clubs` where Ref = 06000012