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
OTAVIO1981
.
Toggle Highlighting
SQL
use ptwiki_p; select log_user_text, log_action, left(log_timestamp, 4) as ano from logging inner join page_restrictions on log_page = pr_page where log_namespace = 4 and log_action = 'protect' and log_title rlike 'Páginas_para_eliminar/' group by ano, select count(page_id), left(page_latest, 4) as ano from page where page_title rlike 'Páginas_para_eliminar/' group by ano
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...