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 usuarios que más ha usado "agradecer" en es_wiki en 202x
Toggle Highlighting
SQL
/* Usuario que más ha usado "agradecer" en 20xx */ SELECT ROW_NUMBER() OVER (PARTITION BY 'Total' ORDER BY COUNT(*) DESC) AS '#', concat('[[Usuario:',actor_name,'|',actor_name,']]') as 'Usuario/a', COUNT(*) as 'Total' FROM logging, actor WHERE log_type= 'thanks' AND actor_id = log_actor AND SUBSTR(log_timestamp,1,4) = '2023' AND log_namespace = '2' GROUP BY actor_name ORDER BY COUNT(*) DESC LIMIT 100
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...