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
The Polish
.
Toggle Highlighting
SQL
SELECT CONCAT('#[[', nstalk.x_nsname, ':', disc.page_title, ']] ([http://it.wikipedia.org/w/index.php?title={{URLENCODE:', nstalk.x_nsname,':', disc.page_title,'}}&action=history Cron] - [[Speciale:PuntanoQui/', nstalk.x_nsname,':', disc.page_title,'|Link]] - [[Special:Undelete/', nspage.x_nsname, ':',disc.page_title, '|pagina]] - 'disc.page_len' byte)') FROM page as disc JOIN x_namespaces as nstalk on disc.page_namespace = nstalk.x_nsnumber JOIN x_namespaces as nspage on (disc.page_namespace -1) = nspage.x_nsnumber WHERE disc.page_namespace = 1 AND disc.page_title NOT LIKE '%/da_fare' AND disc.page_title NOT REGEXP './[Aa]rchiv.' AND disc.page_title NOT IN ( SELECT page_title FROM page WHERE page_namespace = 0 ) ORDER BY disc.page_title;
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...