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

SQL

USE nlwiki_p;

(SELECT page_latest AS rev_id, rev_timestamp AS timestamp, page_title, page_len, "A" as wp10
FROM page
INNER JOIN categorylinks ON page_id = cl_from
INNER JOIN revision ON page_latest = rev_id
WHERE 
	cl_to = "Wikipedia:Etalage-artikelen" AND
 page_namespace = 0)
UNION ALL
(SELECT b.page_latest AS rev_id, rev_timestamp AS timestamp, 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
INNER JOIN revision ON b.page_latest = rev_id
WHERE
	ind.page_namespace = 4 AND
	ind.page_title = "Ruwe_diamanten" AND
    b.page_is_redirect = 0) 
UNION ALL
(SELECT page_latest AS rev_id, rev_timestamp AS timestamp, page_title, page_len, "C" as wp10
FROM page 
INNER JOIN revision ON page_latest = rev_id
WHERE page_len BETWEEN 3000 and 5000
ORDER BY RAND()
 LIMIT 500)
SQL

Checking query status...
