SELECT
	adr.id, adr.name, adr.`number`, adr.city, adr.post, adr.postcode, adr.country_id,
	c.id, c.name, c.code
FROM
	rentacar.addresses as adr
left join
	personsaddresses on adr.id = personsaddresses.person_id
left join
	countries as c on c.id = adr.country_id
where
	personsaddresses.person_id  = 1;