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
Uhai
.
To do: -Expand namespaces (e.g. category, template) -When was page last deleted -Exclude creations by ext confirmed or higher users
Toggle Highlighting
SQL
WITH sock_template AS ( SELECT tl.tl_from FROM enwiki_p.templatelinks tl WHERE tl.tl_target_id IN (32197, 277052, 282063, 115252, 1968835) ) SELECT DISTINCT CONCAT('https://en.wikipedia.org/wiki/', CASE WHEN rc.rc_namespace = 2 THEN 'User:' WHEN rc.rc_namespace = 118 THEN 'Draft:' ELSE '' END, rc.rc_title) AS 'Page', page_len AS 'Page length', TIMESTAMP(rc.rc_timestamp) AS 'Re-created at' FROM enwiki_p.recentchanges_userindex rc INNER JOIN enwiki_p.logging_logindex l ON l.log_type = 'delete' AND l.log_action = 'delete' AND rc.rc_title = l.log_title AND rc.rc_namespace = l.log_namespace INNER JOIN enwiki_p.comment_logging c ON c.comment_id = l.log_comment_id INNER JOIN enwiki_p.page p ON rc.rc_cur_id = p.page_id AND rc.rc_namespace = p.page_namespace AND NOT p.page_is_redirect WHERE rc.rc_new = 1 AND rc.rc_namespace IN (0, 2, 118) AND c.comment_text LIKE '%G5%' AND rc.rc_cur_id NOT IN (SELECT st.tl_from FROM sock_template st) ORDER BY rc.rc_timestamp DESC;
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...