MonographDAO::getUnpublishedMonographsByPressId PHP Method

    function getUnpublishedMonographsByPressId($pressId)
    {
        $params = $this->getFetchParameters();
        $params[] = (int) $pressId;
        $result = $this->retrieve('SELECT	s.*, ps.date_published,
				' . $this->getFetchColumns() . '
			FROM	submissions s
				LEFT JOIN published_submissions ps ON (s.submission_id = ps.submission_id)
				' . $this->getFetchJoins() . '
			WHERE	s.context_id = ? AND
				(ps.submission_id IS NULL OR ps.date_published IS NULL) AND
				s.submission_progress = 0', $params);
        return new DAOResultFactory($result, $this, '_fromRow');
    }