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
Adsum1369
.
Los 100 usuario que más ha usado "agradecer" en es_wiki en 2019
Toggle Highlighting
SQL
/* Usuario que más ha usado "agradecer" en 2019 */ SELECT MAX(actor_name) from ( SELECT actor_name, COUNT(*) as 'Total' FROM logging, actor WHERE log_type= 'thanks' AND actor_id = log_actor AND SUBSTR(log_timestamp,1,4) = '2019' AND log_namespace = '2' )
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...