select paper.paper_id,paper_name, paper_http from paper ,region_master,category_master,periodicity_master,country_master,category where periodicity_master.periodicity_id=paper.periodicity_id and periodicity_master.periodicity='semiweekly' and region_master.region_id=country_master.region_id and paper.country_id=country_master.country_id and region_master.region='Europe' and category_master.category_id=category.category_id and category.paper_id=paper.paper_id and category_master.category='National News' group by paper_name order by paper_name