mainspace pages that have other namespace names

This query is marked as a draft This query has been published by JPxG.
SQL

SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "Talk:%";
SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "User:%";
SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "User talk:%";
SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "Wikipedia:%";
SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "Wikipedia talk:%";
SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "File:%";
SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "File talk:%";
SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "MediaWiki:%";
SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "MediaWiki talk:%";
SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "Template:%";
SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "Template talk:%";
SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "Help:%";
SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "Help talk:%";
SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "Category:%";
SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "Category talk:%";
SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "Portal:%";
SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "Portal talk:%";
SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "Draft:%";
SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "Draft talk:%";
SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "TimedText:%";
SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "TimedText talk:%";
SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "Module:%";
SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "Module talk:%";
SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "Book:%";
SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "Book talk:%";
SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "Course:%";
SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "Course talk:%";
SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "Institution:%";
SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "Institution talk:%";
SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "Education Program:%";
SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "Education Program talk:%";
SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "Flow:%";
SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "Flow talk:%";
SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "Gadget:%";
SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "Gadget talk:%";
SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "Gadget definition:%";
SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "Gadget definition talk:%";
SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "Topic:%";
SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "Topic talk:%";
SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "Special:%";
SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "Special talk:%";
SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "Media:%";
SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "Media talk:%";
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query Stop Query
All SQL code is licensed under CC0 License.
SQL

Checking query status...
