In Umbraco 13's RTE you can insert links to unpublished documents so that when that document is published the link is automatically updated and becomes a working valid link. I have over 300 pages (news articles) that have links all over my site to unpublished documents using this method. Is there a way to generate a list of the Content Node Name and a count of how many times it is linked to? It does not need to be a webpage, a SQL query would work too.
The goal is to get a list of how many times an unpublished node is linked to so I can prioritize which nodes to work on next and get published to fix as many broken links as possible as fast as possible.