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

SQL

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

SQL

Checking query status...