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 = 'HTTP'
AND site_title LIKE 'real_paris%'