Untitled query #49665

SQL

SELECT A.ws AS A_ws, B.ws AS B_ws, A.name AS name FROM
  (
SELECT 'fj' AS 'ws', user_name AS 'name' from fjwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM fjwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'zu', user_name from zuwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM zuwiki_p.user_groups WHERE ug_group = 'bot')
  ) A INNER JOIN (
SELECT 'fj' AS 'ws', user_name AS 'name' from fjwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM fjwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'zu', user_name from zuwiki_p.user WHERE user_editcount > 100 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])(.*)" AND A.ws != B.ws
SQL

Checking query status...
