ugh another rejection, this is the 47th one this year. how many times do i have to rewrite this damn query before someone bites?