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

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,
	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