Untitled query #49664

SQL

WITH sq AS ( SELECT ws 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 '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 'af', user_name from afwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM afwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ak', user_name from akwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM akwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'gsw', user_name from alswiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM alswiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'am', user_name from amwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM amwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ang', user_name from angwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM angwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'an', user_name from anwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM anwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'arc', user_name from arcwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM arcwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ary', user_name from arywiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM arywiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'arz', user_name from arzwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM arzwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ast', user_name from astwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM astwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'as', user_name from aswiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM aswiki_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')
) WHERE A.name NOT RLIKE "(.*)([Bb][Oo][Tt])(.*)" )
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
  sq A INNER JOIN sq B ON A.name = B.name 
) AS C GROUP BY first, second
SQL

Checking query status...
