junk query - Quarry

SQL

/* Featured articles and their FAC pages */
SELECT article.page_title, FAC.page_title, COUNT(*), COUNT(rev_pge), 
MIN(rev_timestamp), MAX(rev_timestamp),
SUBSTRING_INDEX(FAC.page_title, "/", -1) AS ArchiveNum
FROM categorylinks
JOIN page AS article ON article.page_namespace = 0 AND article.page_id = cl_from
JOIN page AS talk    ON    talk.page_namespace = 1 AND talk.page_title = article.page_title
JOIN pagelinks       ON pl_from=talk.page_id AND pl_namespace=4 AND pl_title LIKE "%Featured_article_candidates/%"
JOIN page AS FAC     ON FAC.page_namespace=pl_namespace AND FAC.page_title=pl_title
JOIN revision        ON rev_page = FAC.page_id

WHERE cl_to IN ("Featured_articles")

GROUP BY article.page_id

LIMIT 10;
SQL

Checking query status...
