Index to Chiropractic Literature
Index to Chiropractic Literature
My ICL     Sign In
Tuesday, December 1, 2020
Index to Chiropractic LiteratureIndex to Chiropractic LiteratureIndex to Chiropractic Literature
Share:


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