developing queries for front page report selects