Improve queries for pending files
Getting pending files for campaigns is being intensely slow.
1) currently doing lots of unions, which is slow/bad
2) need to be using campaign info from descriptions.
3) need more caching of SAM info