Wikimedia Bugzilla is closed!

ELECT
  anon_1.user_id AS anon_1_user_id,
  IF(SUM(anon_1.count) >= 5, 1, 0) AS `IF_1`
FROM (
Note "order by null " and archive_userindex  


SELECT
    anon_2.user_id AS user_id,
    anon_2.count AS count
  FROM (
    ( SELECT 
        revision_userindex.rev_user AS user_id,
        count(revision_userindex.rev_user) AS count
      FROM revision_userindex
      WHERE revision_userindex.rev_timestamp BETWEEN '20140716000000' AND '20140815000000'
      GROUP BY revision_userindex.rev_user
      ORDER BY NULL)
    UNION ALL
    ( SELECT
        archive_userindex.ar_user AS user_id,
        count(archive_userindex.ar_user) AS count
      FROM archive_userindex
      WHERE archive_userindex.ar_timestamp BETWEEN '20140716000000' AND '20140815000000'
      GROUP BY archive_userindex.ar_user
      ORDER BY NULL)
  ) AS anon_2
) AS anon_1
GROUP BY anon_1.user_id
ORDER BY NULL;