Dutch Wikipedia Articles by Quality (A, B, and C)

SQL

USE nlwiki_p;
SELECT page_latest AS rev_id, page_title, page_len, "A" as wp10
FROM page
INNER JOIN categorylinks ON page_id = cl_from
WHERE 
	cl_to = "Wikipedia:Etalage-artikelen" AND
    page_namespace = 0
UNION ALL
SELECT b.page_latest AS rev_id, b.page_title, b.page_len, "B" as wp10
FROM page ind
INNER JOIN pagelinks ON pl_from = ind.page_id
INNER JOIN page b ON pl_title = b.page_title AND pl_namespace = b.page_namespace
WHERE
	ind.page_namespace = 4 AND
    ind.page_title = "Ruwe_diamanten"
UNION ALL
SELECT page_latest AS rev_id, page_title, page_len, "C" as wp10
FROM page WHERE page_len BETWEEN 3000 and 5000
ORDER BY RAND()
LIMIT 500;

SQL

Checking query status...