SELECT j.deptID as departmentID, j.subdeptID as subdepartmentID, A.title, A.writerID, A.datecreated, A.dateEdited, A.titletag, A.metadescription, A.metakeywords, A.imageWidth, A.imageHeight, A.imageAlt, A.heading1, A.introduction, A.tagcloud, A.blurb1 FROM articles A, article_dept_join j WHERE A.ID = 0   and A.ID = j.articleID   and j.[primary] = 1