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 count(clow.cl_from) AS num_articles
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
WHERE clow.cl_to REGEXP "^(((Top|High|Mid|Low|Unknown)-importance)|Unassessed).*articles$"
GROUP BY page_id
HAVING count(*) > 1;

SELECT count(clow.cl_from) AS num_articles
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
WHERE clow.cl_to REGEXP "^(((Top|High|Mid|Low|Unknown)-importance)|Unassessed).*articles$"
GROUP BY page_id
HAVING count(*) = 1;

​x
 
USE enwiki_p;SELECT count(clow.cl_from) AS num_articlesFROM (SELECT cl_from      FROM categorylinks      WHERE cl_to='Low-importance_medicine_articles') AS cmedJOIN categorylinks clowON cmed.cl_from=clow.cl_fromWHERE clow.cl_to REGEXP "^(((Top|High|Mid|Low|Unknown)-importance)|Unassessed).*articles$"GROUP BY page_idHAVING count(*) > 1;​SELECT count(clow.cl_from) AS num_articlesFROM (SELECT cl_from      FROM categorylinks      WHERE cl_to='Low-importance_medicine_articles') AS cmedJOIN categorylinks clowON cmed.cl_from=clow.cl_fromWHERE clow.cl_to REGEXP "^(((Top|High|Mid|Low|Unknown)-importance)|Unassessed).*articles$"GROUP BY page_idHAVING 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...