function getByContextId($journalId) { $result = $this->retrieve('SELECT sf.*, g.* FROM submission_galleys g INNER JOIN submissions a ON (g.submission_id = a.submission_id) LEFT JOIN submission_files sf ON (g.file_id = sf.file_id) LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision) WHERE a.context_id = ? AND nsf.file_id IS NULL', (int) $journalId); return new DAOResultFactory($result, $this, '_fromRow'); }