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
Njd-de
.
Toggle Highlighting
SQL
SELECT CONCAT('https://en.wikipedia.org/wiki/', CASE page_namespace WHEN -2 THEN 'Media:' WHEN -1 THEN 'Special:' WHEN 0 THEN '' WHEN 1 THEN 'Talk:' WHEN 2 THEN 'User:' WHEN 3 THEN 'User talk:' WHEN 4 THEN 'Wikipedia:' WHEN 5 THEN 'Wikipedia talk:' WHEN 6 THEN ':File:' WHEN 7 THEN 'File talk:' WHEN 8 THEN 'MediaWiki:' WHEN 9 THEN 'MediaWiki talk:' WHEN 10 THEN 'Template:' WHEN 11 THEN 'Template talk:' WHEN 12 THEN 'Help:' WHEN 13 THEN 'Help talk:' WHEN 14 THEN ':Category:' WHEN 15 THEN 'Category talk:' WHEN 100 THEN 'Portal:' WHEN 101 THEN 'Portal talk:' WHEN 108 THEN 'Book:' WHEN 109 THEN 'Book talk:' WHEN 118 THEN 'Draft:' WHEN 119 THEN 'Draft talk:' WHEN 446 THEN 'Education Program:' WHEN 447 THEN 'Education Program talk:' WHEN 710 THEN 'TimedText:' WHEN 711 THEN 'TimedText talk:' WHEN 828 THEN 'Module:' WHEN 829 THEN 'Module talk:' WHEN 2300 THEN 'Gadget:' WHEN 2301 THEN 'Gadget talk:' WHEN 2302 THEN 'Gadget definition:' WHEN 2303 THEN 'Gadget definition talk:' ELSE CONCAT('{{ns:', page_namespace, '}}:') END, page_title) AS url, CONCAT(CASE page_namespace WHEN -2 THEN 'Media:' WHEN -1 THEN 'Special:' WHEN 0 THEN '' WHEN 1 THEN 'Talk:' WHEN 2 THEN 'User:' WHEN 3 THEN 'User talk:' WHEN 4 THEN 'Wikipedia:' WHEN 5 THEN 'Wikipedia talk:' WHEN 6 THEN ':File:' WHEN 7 THEN 'File talk:' WHEN 8 THEN 'MediaWiki:' WHEN 9 THEN 'MediaWiki talk:' WHEN 10 THEN 'Template:' WHEN 11 THEN 'Template talk:' WHEN 12 THEN 'Help:' WHEN 13 THEN 'Help talk:' WHEN 14 THEN ':Category:' WHEN 15 THEN 'Category talk:' WHEN 100 THEN 'Portal:' WHEN 101 THEN 'Portal talk:' WHEN 108 THEN 'Book:' WHEN 109 THEN 'Book talk:' WHEN 118 THEN 'Draft:' WHEN 119 THEN 'Draft talk:' WHEN 446 THEN 'Education Program:' WHEN 447 THEN 'Education Program talk:' WHEN 710 THEN 'TimedText:' WHEN 711 THEN 'TimedText talk:' WHEN 828 THEN 'Module:' WHEN 829 THEN 'Module talk:' WHEN 2300 THEN 'Gadget:' WHEN 2301 THEN 'Gadget talk:' WHEN 2302 THEN 'Gadget definition:' WHEN 2303 THEN 'Gadget definition talk:' ELSE CONCAT('{{ns:', page_namespace, '}}:') END, REPLACE(page_title, '_', ' ')) AS pagename, page_id FROM page talk WHERE 1=1 AND talk.page_title not like '%/%' -- AND talk.page_title 3like 'O’Brain_Vázquez%' AND talk.page_id NOT IN ( SELECT cl_from FROM categorylinks WHERE 2=3 OR cl_to = 'Wikipedia_orphaned_talk_pages_that_should_not_be_speedily_deleted' OR cl_to = 'Non-orphaned_pages_tagged_with_G8-exempt') /** AND ( 1=2 OR (talk.page_title not in (SELECT page_title from page where page_namespace = 0) AND talk.page_namespace = 1) OR (talk.page_title not in (SELECT page_title from page where page_namespace = 4) AND talk.page_namespace = 5) -- OR (talk.page_title not in (SELECT page_title from page where page_namespace = 6) AND talk.page_namespace = 7) OR (talk.page_title not in (SELECT page_title from page where page_namespace = 10) AND talk.page_namespace = 11) )**/ AND talk.page_title not in (SELECT page_title from page where page_namespace = talk.page_namespace-1) AND talk.page_namespace NOT IN (7) /** file name space has too many "moved to Commons" files AND (talk.page_namespace != 7 OR (talk.page_namespace = 7 AND talk.page_title not in (SELECT img_name from image)) ) **/ -- not in 3 because user talk pages without user page exist, not in 9 because mediawiki contains language file AND talk.page_namespace NOT IN (3, 9) AND talk.page_touched > '20220101000000' AND (talk.page_namespace % 2) > 0 ORDER BY page_namespace, page_title LIMIT 100
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...