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;
Version: unspecified
Severity: normal