BOZ's novels - Quarry

SQL

USE enwiki_p;
SELECT page_title, rev_timestamp
FROM 
	revision_userindex
    JOIN actor_revision ON rev_actor = actor_id
    JOIN page ON rev_page = page_id
WHERE 
	rev_parent_id = 0 AND
    actor_name = "BOZ" AND
    page_namespace = 0 AND
    page_title IN (SELECT page_title 
                  FROM templatelinks
                  JOIN page ON tl_from = page_id
                  WHERE 
                  	tl_from_namespace = 1 AND
                 	tl_namespace = 10 AND
                 	tl_title IN ("WikiProject_Novels", "Novels", "WPNovels", 
                                 "Novels WikiProject", "Novel", "WP Novels", 
                                 "Novelinfoboxincomp", "NovelsWikiProject", 
                                 "WikiProject novels", "WPNOVEL", "Wikiproject Novels"))
ORDER BY rev_timestamp DESC
SQL

Checking query status...
