Untitled query #89720

This query is marked as a draft This query has been published by WikiBayer.

SQL

SELECT
  receiver.actor_name AS user,
  COUNT(*) AS thanks_received
FROM logging
JOIN revision ON logging.log_page = revision.rev_id
JOIN actor AS receiver ON revision.rev_actor = receiver.actor_id
WHERE logging.log_type = 'thanks'
  AND logging.log_action = 'thank'
GROUP BY receiver.actor_name
ORDER BY thanks_received DESC;

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.

SQL

Checking query status...