ad1.text AS app1text, ad1.url AS app1url, ai1.type AS app1type,
adr.city, gp.a2, gp.pays AS countrytxt, gr.name AS region,
IF(u.nom_usage<>'',u.nom_usage,u.nom) AS sortkey,
ad1.text AS app1text, ad1.url AS app1url, ai1.type AS app1type,
adr.city, gp.a2, gp.pays AS countrytxt, gr.name AS region,
IF(u.nom_usage<>'',u.nom_usage,u.nom) AS sortkey,