Page MenuHomePhabricator

DBQ-127 List of Categories assigned to Commons images of the Wikisource PSM project and uploaded by me.
Closed, ResolvedPublic

Description

This issue was converted from https://jira.toolserver.org/browse/DBQ-127.
Summary: List of Categories assigned to Commons images of the Wikisource PSM project and uploaded by me.
Issue type: Task - A task that needs to be done.
Priority: Minor
Status: Done
Assignee: Hoo man <hoo@online.de>


From: Ineuw <ineuw@aei.ca>

Date: Fri, 11 Feb 2011 07:26:47

Would like a list of categories assigned to images I uploaded to the commons and organized under [[Category:Popular Science Monthly illustrations]] - [[User:Ineuw]] was the uploader, and don't need the volume categories.


Version: unspecified
Severity: minor

Details

Reference
bz59381

Event Timeline

bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 2:27 AM
bzimport set Reference to bz59381.

From: Hoo man <hoo@online.de>

Date: Sun, 13 Feb 2011 16:13:08

SQL:

SELECT DISTINCT categorylinks.cl_to as cat FROM (SELECT page.page_id as img_id FROM image INNER JOIN page ON image.img_name = page.page_title INNER JOIN categorylinks ON categorylinks.cl_from = page.page_id INNER JOIN (SELECT page.page_title as cats FROM categorylinks INNER JOIN page ON categorylinks.cl_from = page.page_id WHERE categorylinks.cl_to = 'Popular_Science_Monthly_illustrations' AND page.page_namespace = 14) as subcats ON categorylinks.cl_to = subcats.cats WHERE image.img_user_text = 'Ineuw' AND page.page_namespace = '6') as tmp INNER JOIN categorylinks ON tmp.img_id = categorylinks.cl_from WHERE categorylinks.cl_to NOT LIKE 'Popular_Science_Monthly_illustrations/Volume_%';

Result:
http://toolserver.org/~hoo/dbq/dbq-127.txt


From: Ineuw <ineuw@aei.ca>

Date: Sun, 13 Feb 2011 19:24:00

Hoo man, Many many thanks for the list. It's a real time saver in my future uploads because many images are from serial articles, published months apart.-[[User:Ineuw]]


From: Ineuw <ineuw@aei.ca>

Date: Sun, 09 Oct 2011 04:44:06

Can someone please re-run this query. I added thousands of new images since February 2011. Many thanks


From: Hoo man <hoo@online.de>

Date: Tue, 11 Oct 2011 13:46:32

Result: http://toolserver.org/~hoo/dbq/dbq-127_2.txt (plain text)

Please reopen the request for such things in future ![][1]

[1]: https://jira.toolserver.org/images/icons/emoticons/wink.gif

From: Ineuw <ineuw@aei.ca>

Date: Wed, 09 May 2012 16:35:35

Please reopen and run the query to include images for all volumes regardless of the uploader. Thanks.


From: Hoo man <hoo@online.de>

Date: Tue, 15 May 2012 17:51:10

SQL (only slightly modified):

SELECT DISTINCT categorylinks.cl_to as cat FROM (SELECT page.page_id as img_id FROM page INNER JOIN categorylinks ON categorylinks.cl_from = page.page_id INNER JOIN (SELECT page.page_title as cats FROM categorylinks INNER JOIN page ON categorylinks.cl_from = page.page_id WHERE categorylinks.cl_to = 'Popular_Science_Monthly_illustrations' AND page.page_namespace = 14) as subcats ON categorylinks.cl_to = subcats.cats WHERE page.page_namespace = '6') as tmp INNER JOIN categorylinks ON tmp.img_id = categorylinks.cl_from WHERE categorylinks.cl_to NOT LIKE 'Popular_Science_Monthly_illustrations/Volume_%';

Result:
http://toolserver.org/~hoo/dbq/dbq-127_3.txt


From: Ineuw <ineuw@aei.ca>

Date: Tue, 15 May 2012 18:34:43

Many hanks, Hoo man ![][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: hoo@online.de
CC list: ineuw@aei.ca, hoo@online.de