SELECT sec_lib,s.site_id, s.fle_id,c.key_id, c.key_list, key_url, key_lib as main_key_lib, site_title, kd_description, conf_word, conf_desc, conf_desc_words
FROM dir_site_config c
LEFT JOIN dir_keyword_description USING (kd_id)
LEFT JOIN dir_keyword k ON k.key_id = c.key_id
LEFT JOIN dir_site s ON s.site_id = c.site_id_dest
LEFT JOIN dir_sector USING(sec_id)
WHERE site_url_origin = '/clubGM/sante-et-institutions/institut-francais-de-chirurgie-de-la-main--ifcm'
AND site_title LIKE 'institut_francais_de_chirurgie_de_la_main__ifcm%'