Last modified: 2014-01-03 15:45:52 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T61314, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 59314 - DBQ-59 Find pages which link to [[Yankee Stadium]] directly -- not via templates
DBQ-59 Find pages which link to [[Yankee Stadium]] directly -- not via templates
Status: RESOLVED FIXED
Product: Tool Labs tools
Classification: Unclassified
Database Queries (Other open bugs)
unspecified
All All
: Unprioritized trivial
: ---
Assigned To: Bugzilla Bug Importer (valhallasw)
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2014-01-03 15:45 UTC by Bugzilla Bug Importer (valhallasw)
Modified: 2014-01-03 15:45 UTC (History)
0 users

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Bugzilla Bug Importer (valhallasw) 2014-01-03 15:45:49 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.
Comment 1 Bugzilla Bug Importer (valhallasw) 2014-01-03 15:45:51 UTC
-------------------------------------------------------------------------------
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.
Comment 2 Bugzilla Bug Importer (valhallasw) 2014-01-03 15:45:52 UTC
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

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links