Replicas browser and optimizer
This query is marked as a draft
This query has been published
This query is a simple of the usage of the Thanks tables. It simply fetches, for each recorded "thanks entry", the user that has performed the action, the destination and when it was done. It's then possible to edit this sample query to conduct further data analysis simply by editing the SQL code just below.
use frwiki_p; select WEEKDAY(log_timestamp) as 'timestamp', log_user_text as 'from', log_title as 'to' from logging where log_type='thanks' limit 1000
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in