Wikipedia talk:Database reports/Articles with links to drafts

This just came up at the help desk. I only found it after I'd updated an old query of mine, fixed an egregious case with 222 mainspace links through a template, and doublechecked the draft's whatlinkshere to see if I needed to make any null edits.

My query A) is smarter about filtering out the many, many false positives generated by R with possibilities instead of just excluding all redirects, B) doesn't exclude links to Draft:Sandbox (I take it there used to be a common template that did this? If so, it's not used in mainspace anymore.), and C) groups all mainspace pages with links to a given draft into one line.  C may or may not work well with the bot-generated tables here (example output), but A and B look like strict improvements.

So besides moving this to an advertised subpage of WP:Database reports so it's discoverable, I'd like to hijack this page with my version of the query. Is this going to especially upset anybody? I see there's an anon who's been removing links both from mainspace and this report, but I'd expect most people who'd use this would just wait for an update, or maybe click the trigger-a-manual-update link instead. And yes, I realize I could just make a redundant version and the bot would barely notice, but redundancy bad, mkay? Courtesy ping SD0001, who I suspect doesn't watch the page anymore. —Cryptic 08:01, 10 January 2024 (UTC)
 * @Cryptic Sure, go ahead. This was setup years back as a demo to show the bot's functionality for the BRFA (I didn't even recall why this existed here until I saw the first version's edit summary). Thanks for improving it. – SD0001  (talk) 08:43, 10 January 2024 (UTC)