Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
MrJaroslavik
.
Toggle Highlighting
SQL
SET @ns = 1; # Talk namespace number to search SET @prefix = ''; # Namespace prefix for links (prepended to 'talk:') USE metawiki_p; SELECT CONCAT( '# [[', @prefix, 'talk:', pg.page_title, ']]') AS 'Title' FROM page pg WHERE pg.page_is_redirect = 0 AND pg.page_namespace = @ns AND pg.page_title NOT IN (SELECT pg2.page_title FROM page pg2 WHERE pg2.page_namespace = pg.page_namespace - 1) AND pg.page_title NOT LIKE '%/%' AND pg.page_is_new = 1
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
.
Checking query status...