Untitled query #49664

SQL

SELECT A_ws AS first, B_ws AS second, count( * ) AS overlap FROM
(
  SELECT A.ws AS A_ws, B.ws AS B_ws, A.name AS name FROM
  (
SELECT 'ab' AS 'ws', user_name AS 'name' from abwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM abwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ace', user_name from acewiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM acewiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'id', user_name from idwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM idwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ady', user_name from adywiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM adywiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'zu', user_name from zuwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM zuwiki_p.user_groups WHERE ug_group = 'bot')
  ) A INNER JOIN (
    SELECT 'ab' AS 'ws', user_name AS 'name' from abwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM abwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ace', user_name from acewiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM acewiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'id', user_name from idwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM idwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ady', user_name from adywiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM adywiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'zu', user_name from zuwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM zuwiki_p.user_groups WHERE ug_group = 'bot')
  ) B ON A.name = B.name WHERE A.name NOT RLIKE "(.*)([Bb][Oo][Tt])(.*)"
) AS C GROUP BY first, second
SQL

Checking query status...
