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.ns_name, ':', disc.page_title, ']] ([http://it.wikipedia.org/w/index.php?title={{URLENCODE:', nstalk.ns_name,':', disc.page_title,'}}&action=history Cron] - [[Speciale:PuntanoQui/', nstalk.ns_name,':', disc.page_title,'|Link]] - [[Special:Undelete/', nspage.ns_name, ':',disc.page_title, '|pagina]] - 'disc.page_len' byte)') FROM page as disc JOIN toolserver.namespace as nstalk on disc.page_namespace = nstalk.ns_id JOIN toolserver.namespace as nspage on (disc.page_namespace -1) = nspage.ns_id WHERE nstalk.dbname = 'itwiki_p' AND nspage.dbname = 'itwiki_p' AND disc.page_namespace in (1,5,7,9,11,13,15,101,103) AND disc.page_title NOT LIKE '%/da_fare' AND disc.page_title NOT REGEXP './[Aa]rchiv.' AND NOT EXISTS ( SELECT * FROM page WHERE page_title = disc.page_title AND page_namespace = disc.page_namespace-1 ) ORDER BY nstalk.ns_name, 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...