Replicas browser and optimizer
This query is marked as a draft
This query has been published
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
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in