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...