Replicas browser and optimizer
This query is marked as a draft
This query has been published
SELECT CONCAT('Talk:', page_title) AS talk_page FROM page WHERE page_namespace = 1 AND page_id IN ( SELECT tl_from FROM templatelinks WHERE tl_from_namespace = 1 AND tl_namespace = 10 AND tl_title IN ( "WikiProject_Military_History", "WPCAS", "WikiProject_Colditz", "MILHIST", "Milhist", "WP_Military_History", "WikiProject_MILHIST", "WikiProject_War", "WP_Military_history", "WPMILHIST", "WPMilhist", "MilHist", "Mil_Hist", "WPMH", "WP_Mil", "Military_history", "WPMIL", "WP_MILHIST", "WikiProject_Military" ) ) AND page_id IN ( SELECT tl_from FROM templatelinks tl WHERE tl.tl_namespace = 10 AND tl.tl_title IN ( # 'WikiProject_Ships', 'WPSHIPS', 'WP_Ships', 'WPSHIP', 'WPBOAT' 'WikiProject_Aviation', 'AircraftProject', 'WPAviation', 'WP_Aviation', 'WikiProject_Aircraft', 'WPAVIATION', 'WPPLANE', 'WPAIR', 'WPAIRCRAFT', 'WP_Flight', 'WPAV', 'WikiProject_Aviaton', 'WP_Airport' ) ) AND page_id NOT IN ( SELECT cl_from FROM categorylinks cl2 # WHERE cl2.cl_to = 'Maritime_warfare_task_force_articles' WHERE cl2.cl_to = 'Military_aviation_task_force_articles' )
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