site map

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%'