SELECT villes.id_villes AS villes_id_villes, villes.nom AS villes_nom, departements.numero_departement AS departements_numero_departement, villes.site_mairie AS villes_site_mairie, villes.site_office_tourisme AS villes_site_office_tourisme, villes.titre_presentation AS villes_titre_presentation, villes.presentation AS villes_presentation, villes.meteo AS meteo FROM villes INNER JOIN departements ON villes.id_departement = departements.id_departements WHERE (villes.nom LIKE 'Cert��s')