[
"sql" => "SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.annee_election AS annee_election_2, c0_.statut AS statut_3, c0_.date_candidature AS date_candidature_4, c0_.nb_parrainages AS nb_parrainages_5, c0_.parrainages_publies_le AS parrainages_publies_le_6, c0_.parrainages_source_url AS parrainages_source_url_7, p1_.id AS id_8, p1_.prenom AS prenom_9, p1_.nom AS nom_10, p1_.slug AS slug_11, p1_.date_naissance AS date_naissance_12, p1_.wikidata_id AS wikidata_id_13, p1_.biographie AS biographie_14, p1_.photo_fichier AS photo_fichier_15, p1_.photo_licence AS photo_licence_16, p1_.photo_auteur AS photo_auteur_17, p1_.photo_source_url AS photo_source_url_18, p1_.cree_le AS cree_le_19, p1_.modifie_le AS modifie_le_20, c0_.personnalite_id AS personnalite_id_21 FROM candidat c0_ INNER JOIN personnalite p1_ ON c0_.personnalite_id = p1_.id ORDER BY p1_.nom ASC, p1_.prenom ASC"
]