Last modified: 2014-01-03 15:45:52 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-59. Summary: Find pages which link to [[Yankee Stadium]] directly -- not via templates Issue type: Task - A task that needs to be done. Priority: Trivial Status: Done Assignee: (none) ------------------------------------------------------------------------------- From: Mike Schiraldi <jira@schiraldi.org> Date: Sun, 05 Apr 2009 05:47:01 ------------------------------------------------------------------------------- Until recently, [[Yankee Stadium]] housed the article about the ballpark that opened in 1923. Now it's been changed to house the article about the ballpark that opened in 2009. There are still hundreds of articles that link to [[Yankee Stadium]] that intend to link to the old ballpark. I would like to help direct them to [[Yankee Stadium (1923)]] instead. This can't be scripted, because it requires human judgment of which ballpark is being referred to. To get a list of articles to manually update, I went to the What Links Here page for [[Yankee Stadium]]. Unfortunately, it's filled with false positives (at least for my purposes) that only link there via a template. One example is [[Babe Ruth]]. Therefore, I would like a list of articles that link to [[Yankee Stadium]] directly, not via templates.
------------------------------------------------------------------------------- From: MZMcBride <mzmcbride@gmail.com> Date: Sun, 05 Apr 2009 06:14:17 ------------------------------------------------------------------------------- Ran a DB query to get all page titles that link to "Yankee_Stadium" that are articles and not redirects. SELECT page_title FROM pagelinks JOIN page ON pl_from = page_id WHERE page_namespace = 0 AND page_is_redirect = 0 AND pl_namespace =0 AND pl_title="Yankee_Stadium"; Used a Python to find matches on "Yankee Stadium]]" and output results to http://en.wikipedia.org/w/index.php?oldid=281848590 Resolved as fixed.
This bug was imported as RESOLVED. The original assignee has therefore not been set, and the original reporters/responders have not been added as CC, to prevent bugspam. If you re-open this bug, please consider adding these people to the CC list: Original assignee: (none) CC list: b@mzmcbride.com