This app was mentioned in 8 comments, with an average of 4.75 upvotes
Just in case anyone's wondering, it's IPST (Ingress Portal Submission Tracker)
https://play.google.com/store/apps/details?id=com.einzig.ipst
My oldest unprocessed portal is from Jun 09, 2013 - 1234 days ago
https://play.google.com/store/apps/details?id=com.einzig.ipst&hl=en
It's the second version of this ^^ With OPR happening at a rapid pace nowadays, I've been getting a lot of requests for a fix/new version.
It's IPST. It scans your emails and retrieve the portal submissions confirmation.
If you have submitted portals and deleted the corresponding email prior to installing the app, IPST won't be able to tell for how long it has been in the queue (like on the second picture). There's also a "premium" version.
You can use this to see the status of your portal submissions.
My oldest is 374 days and I don't think I'll ever see another finished review on my submissions.
https://play.google.com/store/apps/details?id=com.einzig.ipst&hl=en
Parses your emails and displays portal submissions/etc. in an ordered fashion.
> ~~some way to check and see if there are any areas that could be turned into a pokestop~~
~~You need to research. If you see a statue in public, look up the artist and see if his/her portfolio contains other public art installed after 2015~~
EDIT: nvm, I misunderstood the question.
Currently there's no tool that allows to show everything that's in the queue.
There is an app IPST which lets you keep track of your own submissions