select a.articleId, tblArticle.articlePages, tblArticle.articleTitle,tblArticle.notes,tblArticle.articleUrl,
					tblJournal.journalId, tblJournal.journalName, 
					tblJournalIssue.volume, tblJournalIssue.startDate, tblJournalIssue.year,tblJournalIssue.issue
				from tmp_res a
					inner join tblArticle on a.articleId=tblArticle.articleId
					left join tblJournal on tblJournal.journalId=tblArticle.journalId
					left join tblJournalIssue on tblJournalIssue.journalIssueId=tblArticle.journalIssueId
				ORDER BY tblJournalIssue.year desc,tblArticle.journalIssueId desc, journalName,  volume, issue