Autoreviewed uploaders in ruwiki

SQL

USE ruwiki_p;
SELECT COUNT(*),
  user_name,
  fr_timestamp AS 'last timestamp',
  CONCAT('https://ru.wikipedia.org/wiki/Служебная:Журналы?type=review&user=', user_name) AS 'review log'
FROM (
  SELECT *
  FROM flaggedrevs
  ORDER BY fr_rev_id DESC
  LIMIT 1000000 -- 4 months
) AS fr_tmp
JOIN user
ON fr_user = user_id
JOIN (
  SELECT *
  FROM (
    SELECT COUNT(*) AS ug_times,
      ug_user,
      ug_group
    FROM user_groups
    GROUP BY ug_user
  ) AS ug_tmp
  WHERE ug_times = 1
  AND ug_group = 'uploader'
) AS ug_tmp2
ON fr_user = ug_user
GROUP BY fr_user
-- LIMIT 100;
SQL

Checking query status...
