SELECT nom_art_lang, nom_clean_art_lang, id_art, id_rel_pg, id_rel_ss_pg, id_art, id_typart, text1_art_lang, active_slide_art FROM `article_langue` INNER JOIN `article` ON `article_langue`.id_rel_art = `article`.id_art INNER JOIN `article_type` ON `article`.id_rel_typart = `article_type`.id_typart INNER JOIN `page` ON `article`.id_rel_pg = `page`.id_pg INNER JOIN `partie` ON `page`.id_rel_part = `partie`.id_part WHERE `article_langue`.id_rel_lang = '1' AND `article_langue`.`nom_clean_art_lang` = 'allegre-les-fumades'