revised date queries and paired down recurring queries to cut out anything that wasn't necessary
queries and markup for listview