WPMED Low-importance articles rated by multiple projects

This query is marked as a draft This query has been published by Nettrom.

To what extent are Low-importance articles in WikiProject Medicine also covered by other WikiProjects? This query gives a rough estimate by identifying the number of importance-related categories a talk page is in.

SQL

USE enwiki_p;
SELECT page_id, page_title, page_namespace
FROM (SELECT cl_from
      FROM categorylinks
      WHERE cl_to='Low-importance_medicine_articles') AS cmed
JOIN categorylinks clow
ON cmed.cl_from=clow.cl_from
JOIN page
ON clow.cl_from=page_id
WHERE clow.cl_to REGEXP "^(((Top|High|Mid|Low|Unknown)-importance)|Unassessed).*articles$"
GROUP BY clow.cl_from
HAVING count(*) > 1;

SELECT page_id, page_title, page_namespace
FROM (SELECT cl_from
      FROM categorylinks
      WHERE cl_to='Low-importance_medicine_articles') AS cmed
JOIN categorylinks clow
ON cmed.cl_from=clow.cl_from
JOIN page
ON clow.cl_from=page_id
WHERE clow.cl_to REGEXP "^(((Top|High|Mid|Low|Unknown)-importance)|Unassessed).*articles$"
GROUP BY clow.cl_from
HAVING count(*) = 1;

​x
 
USE enwiki_p;SELECT page_id, page_title, page_namespaceFROM (SELECT cl_from      FROM categorylinks      WHERE cl_to='Low-importance_medicine_articles') AS cmedJOIN categorylinks clowON cmed.cl_from=clow.cl_fromJOIN pageON clow.cl_from=page_idWHERE clow.cl_to REGEXP "^(((Top|High|Mid|Low|Unknown)-importance)|Unassessed).*articles$"GROUP BY clow.cl_fromHAVING count(*) > 1;​SELECT page_id, page_title, page_namespaceFROM (SELECT cl_from      FROM categorylinks      WHERE cl_to='Low-importance_medicine_articles') AS cmedJOIN categorylinks clowON cmed.cl_from=clow.cl_fromJOIN pageON clow.cl_from=page_idWHERE clow.cl_to REGEXP "^(((Top|High|Mid|Low|Unknown)-importance)|Unassessed).*articles$"GROUP BY clow.cl_fromHAVING count(*) = 1;​

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...