Untitled query #49664

SQL

WITH (
  SELECT 'ar' AS 'ws', user_name AS 'name' from arwikisource_p.user WHERE user_editcount > 1000 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 > 1000 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 > 1000 AND user_id NOT IN (SELECT ug_user FROM zhwikisource_p.user_groups WHERE ug_group = 'bot')
) AS subquery

SELECT distinct first, second, count(name) AS overlap FROM 
(
  SELECT A.ws AS first, B.ws AS second, name FROM
  (
  	subquery A INNER JOIN subquery B ON A.name = B.name
  ) 
)
GROUP BY first, second;
SQL

Checking query status...
