added getAllByStatus for @mnewmedia