Most thanking/thanked users in the year 2022 of Farsi Wikipedia

SQL

-- Most thanked, last 12 months
SELECT
    log_title as thanked_last_year, COUNT(*) as count
  FROM
    logging
  WHERE
    log_type = "thanks" AND
    log_timestamp >= "20230000000000" AND
	log_timestamp <= "20240000000000"
  GROUP BY
    log_title
  ORDER BY
    count DESC, log_title
  LIMIT
    100;
    
-- Most thanking, last 12 months
SELECT
    actor_name as thanking_last_year, COUNT(*) as count
  FROM
    logging, actor_user
  WHERE
    actor_id = log_actor and
    log_type = "thanks" AND
    log_timestamp >= "20230000000000" AND
	log_timestamp <= "20240000000000"
  GROUP BY
    actor_name
  ORDER BY
    count DESC, actor_name
  LIMIT
    100;

SQL

Checking query status...