SELECT 
	a.id_a,a.nom,a.public,a.categorie,a.publication,a.donnees,a.photo,
	v.code_postal, v.nom AS ville
FROM 
	lvi.g_adresses a INNER JOIN ancre.l_villes v USING (id_l_v)
WHERE
	id_l_r=10 AND
	 categorie=4 AND onscreen='o'
	ORDER BY nom ASC