Last modified: 2014-01-03 15:22:25 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-6. Summary: List of pages containing a slash on en.wiki Issue type: Task - A task that needs to be done. Priority: Major Status: Done Assignee: Dan Collins <EN.WP.ST47@gmail.com> ------------------------------------------------------------------------------- From: MZMcBride <mzmcbride@gmail.com> Date: Mon, 24 Dec 2007 19:58:20 ------------------------------------------------------------------------------- If possible, I would like two lists: one list containing all pages in ns:0 on en.wiki that contain a forward slash ( / ), and the second list containing all pages in ns:1 on en.wiki that contain a forward slash. Kind of an odd query request, I realize. I can take the list in any format, though I realize the second list will undoubtedly be very, very large. Cheers.
------------------------------------------------------------------------------- From: Dan Collins <EN.WP.ST47@gmail.com> Date: Mon, 24 Dec 2007 20:29:53 ------------------------------------------------------------------------------- The first list is almost 30000 items long.
------------------------------------------------------------------------------- From: Misza <misza1313@gmail.com> Date: Mon, 24 Dec 2007 20:31:57 ------------------------------------------------------------------------------- Just a comment to prepare whomever is up for the task (I might later): select count(*) from page where page_title like '%/%' and page_namespace = 0; gives nearly 30K, namespace 1 gives over 50K. Thus, an email deilvery of the result will probably be the best option.
------------------------------------------------------------------------------- From: Dan Collins <EN.WP.ST47@gmail.com> Date: Mon, 24 Dec 2007 20:37:21 ------------------------------------------------------------------------------- http://tools.wikimedia.de/~st47/MZMB1.txt http://tools.wikimedia.de/~st47/MZMB2.txt
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: EN.WP.ST47@gmail.com CC list: b@mzmcbride.com, misza@misza.net, EN.WP.ST47@gmail.com
