Replicas browser and optimizer
This query is marked as a draft
This query has been published
The 100 people who have received the most Wikilove in the past year. Last run May 20, 2016
SELECT user_name, wikilove_messages FROM (SELECT user_name, COUNT(wll_id) AS wikilove_messages FROM user u INNER JOIN wikilove_log wl ON u.user_id = wl.wll_receiver where wl.wll_timestamp > 20150520000000 GROUP BY user_name ORDER BY wikilove_messages DESC) AS tmp;
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