Danish assessed articles

SQL

USE dawiki_p;
SELECT count(DISTINCT page_title) AS num_b
FROM page JOIN categorylinks
ON page_id=cl_from
WHERE page_namespace IN (0,1)
AND cl_to LIKE 'Klasse\_B-%artikler';
SELECT count(DISTINCT page_title) AS num_start
FROM page JOIN categorylinks
ON page_id=cl_from
WHERE page_namespace IN (0,1)
AND cl_to LIKE 'Klasse\_Start%artikler';
SELECT count(DISTINCT page_title) AS num_stub
FROM page JOIN categorylinks
ON page_id=cl_from
WHERE page_namespace IN (0,1)
AND cl_to LIKE 'Klasse\_Stub%artikler';
-- Give me some random articles in each category
SELECT page_id, page_title
FROM page
JOIN categorylinks
ON page_id=cl_from
WHERE page_namespace IN (0,1)
AND cl_to LIKE 'Klasse\_B%artikler'
AND page_random > (SELECT RAND() AS randn)
ORDER BY page_random LIMIT 25;
SELECT page_id, page_title
FROM page
JOIN categorylinks
ON page_id=cl_from
WHERE page_namespace IN (0,1)
AND cl_to LIKE 'Klasse\_Start%artikler'
AND page_random > (SELECT RAND() AS randn)
ORDER BY page_random LIMIT 25;
SELECT page_id, page_title
FROM page
JOIN categorylinks
ON page_id=cl_from
WHERE page_namespace IN (0,1)
AND cl_to LIKE 'Klasse\_Stub%artikler'
AND page_random > (SELECT RAND() AS randn)
ORDER BY page_random LIMIT 25;
SQL

Checking query status...
