restructured the query to show only pending alerts that are due two weeks into the future