Last modified: 2014-01-03 16:01:46 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-136. Summary: Article titles and their categories from the Wikisource Popular Science Monthly Project Volumes 1 to 25 inclusive Issue type: Task - A task that needs to be done. Priority: Minor Status: Done Assignee: (none) ------------------------------------------------------------------------------- From: Ineuw <ineuw@aei.ca> Date: Sun, 10 Apr 2011 07:23:43 ------------------------------------------------------------------------------- I need a list of the articles with their assigned categories from the Wikisource Popular Science Monthly Project of Volumes 1 to 25. http://en.wikisource.org/wiki/Popular_Science_Monthly/Volume_1/May_1872/The_Study_of_Sociology_I being the first article. Thank you.
------------------------------------------------------------------------------- From: Hoo man <hoo@online.de> Date: Fri, 22 Apr 2011 22:25:36 ------------------------------------------------------------------------------- I did it that way: I got all pages (namespace 0) from the categories 'Popular_Science_Monthly_Volume_1-25' and saved them in a temporary table. Afterwards I got all categories for these pages. I hope that's what you wanted ![][1] SQL: SELECT page.page_title FROM categorylinks INNER JOIN page ON page.page_id = categorylinks.cl_from WHERE cl_to IN ( 'Popular_Science_Monthly_Volume_1', 'Popular_Science_Monthly_Volume_2', /* ... */ 'Popular_Science_Monthly_Volume_25') AND page.page_namespace = 0; SELECT dbq136.page_title, categorylinks.cl_to FROM u_hoo.dbq136 INNER JOIN page ON dbq136.page_title = page.page_title INNER JOIN categorylinks ON categorylinks.cl_from = page.page_id WHERE page.page_namespace = 0; Result: http://toolserver.org/~hoo/dbq/dbq-136.txt (plain text) [1]: https://jira.toolserver.org/images/icons/emoticons/wink.gif
------------------------------------------------------------------------------- From: Ineuw <ineuw@aei.ca> Date: Fri, 22 Apr 2011 23:47:22 ------------------------------------------------------------------------------- Hi Hoo man. Many many thanks - it's perfect. Can we save this SQL statement for future use since I am working on volumes 26 to 50? Have a great weekend. Ineuw
------------------------------------------------------------------------------- From: Hoo man <hoo@online.de> Date: Sat, 23 Apr 2011 00:17:05 ------------------------------------------------------------------------------- Np ![][1] Of course you can save, reuse or do whatever with the above SQL [1]: https://jira.toolserver.org/images/icons/emoticons/wink.gif
------------------------------------------------------------------------------- From: Ineuw <ineuw@aei.ca> Date: Tue, 21 Feb 2012 09:00:00 ------------------------------------------------------------------------------- Please rerun this query as you did a year ago. The difference is that I expanded the volume range from 1 to 50. All other parameters and details are the same. Please see below, Thank you. SELECT page.page_title FROM categorylinks INNER JOIN page ON page.page_id = categorylinks.cl_from WHERE cl_to IN ( 'Popular_Science_Monthly_Volume_1', 'Popular_Science_Monthly_Volume_2', /* ... */ 'Popular_Science_Monthly_Volume_50') AND page.page_namespace = 0; SELECT dbq136.page_title, categorylinks.cl_to FROM u_hoo.dbq136 INNER JOIN page ON dbq136.page_title = page.page_title INNER JOIN categorylinks ON categorylinks.cl_from = page.page_id WHERE page.page_namespace = 0;
------------------------------------------------------------------------------- From: Hoo man <hoo@online.de> Date: Tue, 21 Feb 2012 13:55:48 ------------------------------------------------------------------------------- http://toolserver.org/~hoo/dbq/dbq-136_2.txt ![][1] [1]: https://jira.toolserver.org/images/icons/emoticons/wink.gif
------------------------------------------------------------------------------- From: Ineuw <ineuw@aei.ca> Date: Thu, 15 Nov 2012 03:03:50 ------------------------------------------------------------------------------- Can this be query be run again to include volumes 1 to 54? Thanks
------------------------------------------------------------------------------- From: Hoo man <hoo@online.de> Date: Sat, 17 Nov 2012 23:13:16 ------------------------------------------------------------------------------- Here you go: http://toolserver.org/~hoo/dbq/dbq-136_3.txt
------------------------------------------------------------------------------- From: Ineuw <ineuw@aei.ca> Date: Mon, 19 Nov 2012 02:48:38 ------------------------------------------------------------------------------- hoo, as usual, I and the 19th century thanks you. ![][1] [1]: https://jira.toolserver.org/images/icons/emoticons/smile.gif
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: ineuw@aei.ca, hoo@online.de