// Build the addresses tree
$res = XDB::query("SELECT a.adrid AS id, a.adr1, a.adr2, a.adr3,
UNIX_TIMESTAMP(a.datemaj) AS datemaj,
a.postcode, a.city, a.cityid, a.region, a.regiontxt,
a.pub, a.country, gp.pays AS countrytxt, gp.display,
// Build the addresses tree
$res = XDB::query("SELECT a.adrid AS id, a.adr1, a.adr2, a.adr3,
UNIX_TIMESTAMP(a.datemaj) AS datemaj,
a.postcode, a.city, a.cityid, a.region, a.regiontxt,
a.pub, a.country, gp.pays AS countrytxt, gp.display,