For best results switch to Advanced Search. |
[dblib] : Table 'chiroan_wp2020.tmp_res' doesn't exist
insert into tmp_res(articleId,rank) select tblArticle.articleId, ifnull(tmp_1.rank,0) from tblArticle left join tblJournal on tblJournal.journalId=tblArticle.journalId left join tblJournalIssue on tblJournalIssue.journalIssueId=tblArticle.journalIssueId left join tmp_1 on tmp_1.articleId = tblArticle.articleId WHERE tblArticle.status='approved' AND (tmp_1.articleId IS NOT NULL) -- ORDER BY rank desc, articleTitle