Index to Chiropractic Literature
Index to Chiropractic Literature
My ICL   Sign In
Tuesday, September 25, 2018
Index to Chiropractic LiteratureIndex to Chiropractic LiteratureIndex to Chiropractic LiteratureIndex to Chiropractic Literature
Share:

ICL Home


For best results switch to Advanced Search. More search tips.
[dblib] 1064: 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 ') ORDER BY ji.year desc,a.journalIssueId desc, journalName, volume, issue' at line 12
    			select a.*, u.userName as enteredByName, 
    	  	    a.peerReviewed,
       			j.journalName , j.journalTitle , j.ISSN,
       			ji.startDate, ji.year, ji.volume, ji.issue,
       			 pt.ptName as ptName,
       			a.notes
        		from tblArticle a
        		left join tblJournal j on j.journalId=a.journalId
        		left join tblJournalIssue ji on ji.journalIssueId=a.journalIssueId
        		left join tblUser u on u.userId=a.enteredBy
        		left join tblPublicationType pt on pt.ptId=a.ptId
        		where articleId in () 
			ORDER BY ji.year desc,a.journalIssueId desc, journalName,  volume, issue