select paper.paper_id,paper_name, paper_http from paper ,language_master,periodicity_master where periodicity_master.periodicity_id=paper.periodicity_id and periodicity_master.periodicity='daily twice' and language_master.language_id=paper.language_id and language_master.language='Gujarati' group by paper_name order by paper_name