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