Index to Chiropractic Literature
Index to Chiropractic Literature
My ICL     Sign In
Wednesday, December 1, 2021
Index to Chiropractic LiteratureIndex to Chiropractic LiteratureIndex to Chiropractic Literature
Share:

[dblib] : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(tmp_2.articleId IS NOT NULL)) AND tblArticle.peerReviewed=1 -- ORDER...' at line 11
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
        left join tmp_2 on tmp_2.articleId = tblArticle.articleId
             
     	WHERE tblArticle.status='approved'
     	 AND ( (1=1)  (tmp_2.articleId IS NOT NULL))   AND tblArticle.peerReviewed=1 
--     	ORDER BY rank desc, articleTitle