SQL
AخA
SELECT
actor_name,
bot.ug_group AS is_bot,
admin.ug_group AS is_admin,
COUNT(DISTINCT ar_page_id) AS cnt
FROM
archive
JOIN actor_archive ON ar_actor=actor_id
LEFT JOIN user ON actor_user=user_id
LEFT JOIN user_groups AS bot ON bot.ug_user=user_id AND bot.ug_group='bot'
LEFT JOIN user_groups AS admin ON admin.ug_user=user_id AND admin.ug_group='sysop'
WHERE
ar_parent_id=0
GROUP BY
actor_name,
is_bot,
is_admin
HAVING
cnt>=10
ORDER BY
cnt DESC;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.