Untitled query #49664

SQL

SELECT A.A_ws AS first, B.B_ws AS second, count( name ) AS overlap FROM
(
  SELECT
  (
    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')
  ) A INNER JOIN A B ON A.name = B.name
) AS C GROUP BY first, second
SQL

Checking query status...
