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
ⵓ
.
Toggle Highlighting
SQL
USE dewiki_p; SET sql_mode='PIPES_AS_CONCAT'; SELECT '[https://de.wikipedia.org/w/index.php?action=history&curid='||page_id||' ' || page_title || ']' AS history, count(*) AS edits FROM page INNER JOIN revision on page.page_id=revision.rev_page WHERE page_len=0 and page_namespace=1 and exists (select 1 from revision as r where r.rev_user=633938 and r.rev_page=page_id) GROUP BY page.page_id
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...