select paper.paper_id,paper_name, paper_http from paper ,category_master,language_master,periodicity_master,category where language_master.language_id=paper.language_id and language_master.language='Portuguese' and category_master.category_id=category.category_id and category.paper_id=paper.paper_id
					and category_master.category='Local News' and periodicity_master.periodicity_id=paper.periodicity_id and periodicity_master.periodicity='weekly' group by paper_name order by paper_name