Replicas browser and optimizer
This query is marked as a draft
This query has been published
People who have sent Stroopwafels via Wikilove between August 27, 2013 and August 27 2014. And the number of wafels sent per user.
SELECT user_name, COUNT(wll_id) waffles_sent FROM user u INNER JOIN wikilove_log wl ON u.user_id = wl.wll_sender WHERE wl.wll_type = "food-stroopwafels" AND wl.wll_timestamp > 20130827000000 GROUP BY user_name ORDER BY waffles_sent DESC;
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