[enwn] Find n-recent published stories in a particular category

SQL

USE enwikinews_p;
#SELECT page_title, page_namespace, page_id FROM page
#WHERE page_namespace = 0
#AND EXISTS (
#  SELECT cl_from, cl_to FROM categorylinks
#  WHERE page_id = cl_from
#  AND cl_to="GitHub"
#)
#AND EXISTS (
#  SELECT cl_from, cl_to, cl_timestamp FROM categorylinks
#  WHERE page_id = cl_from
#  AND cl_to="Published"
#)
#LIMIT 20
#ORDER BY cl_timestamp DESC
#;
SELECT page_title, page_namespace, cl_timestamp, cl_from, cl_to
FROM page
FULL JOIN categorylinks
ON page_id = cl_from
WHERE (page_namespace = 0 AND cl_to="Published")
LIMIT 10
;

SQL

Checking query status...