Last modified: 2014-01-03 15:58:02 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-118. Summary: List of living people who have a good articles in enwiki Issue type: Task - A task that needs to be done. Priority: Major Status: Done Assignee: Hoo man <hoo@online.de> ------------------------------------------------------------------------------- From: Mjbmr <mjbmri@gmail.com> Date: Thu, 30 Dec 2010 18:59:26 ------------------------------------------------------------------------------- I would like have a list of articles in enwiki that they are exits in "Good articles" category and "Living people" category, thank you in advance
------------------------------------------------------------------------------- From: Hoo man <hoo@online.de> Date: Fri, 31 Dec 2010 10:21:03 ------------------------------------------------------------------------------- SQL: SELECT page.page_title as page FROM categorylinks INNER JOIN categorylinks as catlinks ON categorylinks.cl_from = catlinks.cl_from INNER JOIN page ON categorylinks.cl_from = page.page_id WHERE categorylinks.cl_to = 'Good_articles' AND catlinks.cl_to = 'Living_people'; Result: http://toolserver.org/~hoo/dbq/dbq-118.txt (plain text) http://toolserver.org/~hoo/dbq/dbq-118_wiki.txt (wiki table)
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: hoo@online.de, mjbmri@gmail.com