select paper.paper_id,paper_name, paper_http from paper ,region_master,language_master,periodicity_master,country_master where periodicity_master.periodicity_id=paper.periodicity_id and periodicity_master.periodicity='weekly' and language_master.language_id=paper.language_id and language_master.language='French' and region_master.region_id=country_master.region_id and paper.country_id=country_master.country_id  and region_master.region='North America' group by paper_name