SELECT exposant.id, exposant.nom AS nom, site, logo FROM exposant LEFT JOIN exposant_edition ON exposant_edition.id_societe = exposant.id WHERE exposant_edition.id_edition= 1 AND substring(exposant.nom,1,1)='a' GROUP BY exposant.id ORDER BY exposant.nom ASC1