DBQ-118 List of living people who have a good articles in enwiki
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	JiraBugConverter
	Jan 3 2014, 3:57 PM

Description

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

Version: unspecified
Severity: major

Details

Reference: bz59370

Event Timeline

• bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 2:26 AM

• bzimport added a project: Tool-Database-Queries.

• bzimport set Reference to bz59370.

JiraBugConverter created this task.Jan 3 2014, 3:57 PM

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

DBQ-118 List of living people who have a good articles in enwikiClosed, ResolvedPublicActions