Count contributions of last 30 days in several wikis

SQL

SELECT CONCAT('User:', rc_user_text, '@', wiki, 'wikipedia'), num_contribs 
FROM (SELECT
    rc_user_text,
    COUNT(1) AS num_contribs, 'sw' as wiki
    from swwiki_p.recentchanges
WHERE
    rc_logid = 0 AND rc_user != 0
    and rc_bot = 0 and rc_user_text != "Salebot"
    and rc_user_text != "MediaWiki message delivery"
    and rc_user_text != "CommonsDelinker"

GROUP BY rc_user
Having COUNT(1) > 1
UNION ALL
SELECT
    rc_user_text,
    COUNT(1) AS num_contribs, 'wo' as wiki
    from wowiki_p.recentchanges
WHERE
    rc_logid = 0 AND rc_user != 0
    and rc_bot = 0 and rc_user_text != "Salebot"
    and rc_user_text != "MediaWiki message delivery"
    and rc_user_text != "CommonsDelinker"

GROUP BY rc_user
Having COUNT(1) > 1
UNION ALL
SELECT
    rc_user_text,
    COUNT(1) AS num_contribs, 'zu' as wiki
    from zuwiki_p.recentchanges
WHERE
    rc_logid = 0 AND rc_user != 0
    and rc_bot = 0 and rc_user_text != "Salebot"
    and rc_user_text != "MediaWiki message delivery"
    and rc_user_text != "CommonsDelinker"

GROUP BY rc_user
Having COUNT(1) > 1
UNION ALL
SELECT
    rc_user_text,
    COUNT(1) AS num_contribs, 'xh' as wiki
    from xhwiki_p.recentchanges
WHERE
    rc_logid = 0 AND rc_user != 0
    and rc_bot = 0 and rc_user_text != "Salebot"
    and rc_user_text != "MediaWiki message delivery"
    and rc_user_text != "CommonsDelinker"

GROUP BY rc_user
Having COUNT(1) > 1
UNION ALL
SELECT
    rc_user_text,
    COUNT(1) AS num_contribs, 'arz' as wiki
    from arzwiki_p.recentchanges
WHERE
    rc_logid = 0 AND rc_user != 0
    and rc_bot = 0 and rc_user_text != "Salebot"
    and rc_user_text != "MediaWiki message delivery"
    and rc_user_text != "CommonsDelinker"

GROUP BY rc_user
Having COUNT(1) > 1
UNION ALL
SELECT
    rc_user_text,
    COUNT(1) AS num_contribs, 'bm' as wiki
    from bmwiki_p.recentchanges
WHERE
    rc_logid = 0 AND rc_user != 0
    and rc_bot = 0 and rc_user_text != "Salebot"
    and rc_user_text != "MediaWiki message delivery"
    and rc_user_text != "CommonsDelinker"

GROUP BY rc_user
Having COUNT(1) > 1
UNION ALL
SELECT
    rc_user_text,
    COUNT(1) AS num_contribs, 'af' as wiki
    from afwiki_p.recentchanges
WHERE
    rc_logid = 0 AND rc_user != 0
    and rc_bot = 0 and rc_user_text != "Salebot"
    and rc_user_text != "MediaWiki message delivery"
    and rc_user_text != "CommonsDelinker"

GROUP BY rc_user
Having COUNT(1) > 1

      ORDER BY num_contribs DESC) as t
      GROUP BY rc_user_text;
SQL

Checking query status...
