added publish_event_id to dashboard calendar query/subquery to test for null for draft status