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
.
Toggle Highlighting
SQL
/* Usuario que más ha usado "agradecer" en 20xx */ SELECT actor_name as 'Usuario', SUBSTR(log_timestamp,1,8) as 'AAAADDMM' , SUBSTR(log_timestamp,9,6) AS 'hhmmss' FROM logging, actor WHERE log_type= 'thanks' AND actor_id = log_actor AND SUBSTR(log_timestamp,1,8) = '20211231' AND log_namespace = '2' ORDER BY log_timestamp 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...