SELECT f.departmentID, f.sort, o.title,o.shortDescription, o.fileName, o.metaTitle, o.metaDescription, o.keywords, o.content, o.template, o.layout, o.buildDate, o.editDate, o.lastUser, o.status FROM fusion f INNER JOIN departments o ON f.departmentID = o.departmentID WHERE (f.ownerID = ?) AND (f.objectType = ?) AND (o.status = ?) ORDER BY f.sort " content="index,follow" />