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 FROM
  (
    SELECT 'ar' AS 'ws', user_name AS 'name' from arwikisource_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM arwikisource_p.user_groups WHERE ug_group = 'bot') UNION
    SELECT 'as', user_name AS 'name' from aswikisource_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM aswikisource_p.user_groups WHERE ug_group = 'bot') UNION
    SELECT 'zh', user_name AS 'name' from zhwikisource_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM zhwikisource_p.user_groups WHERE ug_group = 'bot') UNION
    SELECT 'en', user_name AS 'name' from enwikisource_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM enwikisource_p.user_groups WHERE ug_group = 'bot')
  ) A INNER JOIN (
    SELECT 'ar' AS 'ws', user_name AS 'name' from arwikisource_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM arwikisource_p.user_groups WHERE ug_group = 'bot') UNION
    SELECT 'as', user_name AS 'name' from aswikisource_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM aswikisource_p.user_groups WHERE ug_group = 'bot') UNION
    SELECT 'zh', user_name AS 'name' from zhwikisource_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM zhwikisource_p.user_groups WHERE ug_group = 'bot') UNION
    SELECT 'en', user_name AS 'name' from enwikisource_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM enwikisource_p.user_groups WHERE ug_group = 'bot')
  ) B ON A.name = B.name
) AS C GROUP BY first, second
SQL

Checking query status...
