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
CONNECT itwiki_p itwiki.labsdb; SELECT CONCAT('# [[', nstalk.ns_name, ':', disc.page_title, ']] (', DATE_FORMAT(rev_timestamp, '%e %b %Y, %H:%i'), ')') FROM page AS disc JOIN p50380g50614__lists.ns_it AS nstalk ON disc.page_namespace = nstalk.ns_id JOIN p50380g50614__lists.ns_it AS nspage ON (disc.page_namespace - 1) = nspage.ns_id JOIN revision ON disc.page_latest = rev_id WHERE 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, rev_timestamp, 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...