Untitled query #49664

This query is marked as a draft This query has been published by Yair rand.
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, A.name AS name FROM
  (
SELECT 'ace' AS 'ws', user_name AS 'name' from acewiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM acewiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'af', user_name from afwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM afwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'als', user_name from alswiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM alswiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'an', user_name from anwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM anwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'arz', user_name from arzwiki_p.user WHERE user_editcount > 100 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 > 100 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 > 100 AND user_id NOT IN (SELECT ug_user FROM aswiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ay', user_name from aywiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM aywiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'azb', user_name from azbwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM azbwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'az', user_name from azwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM azwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'bar', user_name from barwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM barwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ba', user_name from bawiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM bawiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'bcl', user_name from bclwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM bclwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'be', user_name from bewiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM bewiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'be-tarask', user_name from be_x_oldwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM be_x_oldwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'bg', user_name from bgwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM bgwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'bh', user_name from bhwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM bhwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'bjn', user_name from bjnwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM bjnwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'br', user_name from brwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM brwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'bs', user_name from bswiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM bswiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ca', user_name from cawiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM cawiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ceb', user_name from cebwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM cebwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ce', user_name from cewiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM cewiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ckb', user_name from ckbwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM ckbwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'crh', user_name from crhwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM crhwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'cv', user_name from cvwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM cvwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'cy', user_name from cywiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM cywiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'da', user_name from dawiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM dawiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'diq', user_name from diqwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM diqwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'dty', user_name from dtywiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM dtywiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'dv', user_name from dvwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM dvwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'el', user_name from elwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM elwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'eml', user_name from emlwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM emlwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'eo', user_name from eowiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM eowiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'et', user_name from etwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM etwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'eu', user_name from euwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM euwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'fi', user_name from fiwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM fiwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'fj', user_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 'frp', user_name from frpwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM frpwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'frr', user_name from frrwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM frrwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'fy', user_name from fywiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM fywiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ga', user_name from gawiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM gawiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'glk', user_name from glkwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM glkwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'gl', user_name from glwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM glwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'gor', user_name from gorwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM gorwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'gu', user_name from guwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM guwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'hak', user_name from hakwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM hakwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ha', user_name from hawiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM hawiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'haw', user_name from hawwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM hawwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'hif', user_name from hifwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM hifwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'hr', user_name from hrwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM hrwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'hsb', user_name from hsbwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM hsbwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ht', user_name from htwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM htwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'hu', user_name from huwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM huwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'hy', user_name from hywiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM hywiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'hyw', user_name from hywwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM hywwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ia', user_name from iawiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM iawiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ie', user_name from iewiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM iewiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ig', user_name from igwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM igwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ilo', user_name from ilowiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM ilowiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'inh', user_name from inhwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM inhwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'io', user_name from iowiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM iowiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'is', user_name from iswiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM iswiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'jv', user_name from jvwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM jvwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'kab', user_name from kabwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM kabwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ka', user_name from kawiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM kawiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'kk', user_name from kkwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM kkwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'km', user_name from kmwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM kmwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'kn', user_name from knwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM knwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ku', user_name from kuwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM kuwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'kw', user_name from kwwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM kwwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ky', user_name from kywiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM kywiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'la', user_name from lawiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM lawiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'lb', user_name from lbwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM lbwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'lfn', user_name from lfnwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM lfnwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'lij', user_name from lijwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM lijwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'li', user_name from liwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM liwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'lmo', user_name from lmowiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM lmowiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'lo', user_name from lowiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM lowiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'lrc', user_name from lrcwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM lrcwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'lt', user_name from ltwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM ltwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'lv', user_name from lvwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM lvwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'mai', user_name from maiwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM maiwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'mhr', user_name from mhrwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM mhrwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'min', user_name from minwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM minwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'mk', user_name from mkwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM mkwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ml', user_name from mlwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM mlwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'mn', user_name from mnwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM mnwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'mrj', user_name from mrjwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM mrjwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'mr', user_name from mrwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM mrwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ms', user_name from mswiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM mswiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'mt', user_name from mtwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM mtwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'myv', user_name from myvwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM myvwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'my', user_name from mywiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM mywiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'mzn', user_name from mznwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM mznwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'nap', user_name from napwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM napwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'nds', user_name from ndswiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM ndswiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ne', user_name from newiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM newiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'nn', user_name from nnwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM nnwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'no', user_name from nowiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM nowiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'nrm', user_name from nrmwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM nrmwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'nv', user_name from nvwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM nvwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'oc', user_name from ocwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM ocwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'or', user_name from orwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM orwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'os', user_name from oswiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM oswiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'pap', user_name from papwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM papwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'pa', user_name from pawiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM pawiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'pms', user_name from pmswiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM pmswiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'pnb', user_name from pnbwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM pnbwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ps', user_name from pswiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM pswiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'qu', user_name from quwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM quwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'rm', user_name from rmwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM rmwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ro', user_name from rowiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM rowiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'rue', user_name from ruewiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM ruewiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'sah', user_name from sahwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM sahwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'sat', user_name from satwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM satwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'sa', user_name from sawiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM sawiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'sco', user_name from scowiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM scowiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'sc', user_name from scwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM scwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'sd', user_name from sdwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM sdwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'shn', user_name from shnwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM shnwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'sh', user_name from shwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM shwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'simple', user_name from simplewiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM simplewiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'si', user_name from siwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM siwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'sk', user_name from skwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM skwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'sl', user_name from slwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM slwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'sn', user_name from snwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM snwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'so', user_name from sowiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM sowiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'sq', user_name from sqwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM sqwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'sr', user_name from srwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM srwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'stq', user_name from stqwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM stqwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'su', user_name from suwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM suwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'sv', user_name from svwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM svwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'sw', user_name from swwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM swwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'szl', user_name from szlwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM szlwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'szy', user_name from szywiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM szywiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ta', user_name from tawiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM tawiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'tcy', user_name from tcywiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM tcywiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'te', user_name from tewiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM tewiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'tg', user_name from tgwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM tgwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'th', user_name from thwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM thwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'tk', user_name from tkwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM tkwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'tl', user_name from tlwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM tlwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'tt', user_name from ttwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM ttwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'tyv', user_name from tyvwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM tyvwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ur', user_name from urwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM urwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'uz', user_name from uzwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM uzwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'vec', user_name from vecwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM vecwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'vep', user_name from vepwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM vepwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'vo', user_name from vowiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM vowiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'war', user_name from warwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM warwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'wa', user_name from wawiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM wawiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'wuu', user_name from wuuwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM wuuwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'xmf', user_name from xmfwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM xmfwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'yi', user_name from yiwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM yiwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'yo', user_name from yowiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM yowiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'zh-classical', user_name from zh_classicalwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM zh_classicalwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'zh-yue', user_name from zh_yuewiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM zh_yuewiki_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 'ace' AS 'ws', user_name AS 'name' from acewiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM acewiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'af', user_name from afwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM afwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'als', user_name from alswiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM alswiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'an', user_name from anwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM anwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'arz', user_name from arzwiki_p.user WHERE user_editcount > 100 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 > 100 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 > 100 AND user_id NOT IN (SELECT ug_user FROM aswiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ay', user_name from aywiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM aywiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'azb', user_name from azbwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM azbwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'az', user_name from azwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM azwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'bar', user_name from barwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM barwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ba', user_name from bawiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM bawiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'bcl', user_name from bclwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM bclwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'be', user_name from bewiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM bewiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'be-tarask', user_name from be_x_oldwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM be_x_oldwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'bg', user_name from bgwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM bgwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'bh', user_name from bhwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM bhwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'bjn', user_name from bjnwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM bjnwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'br', user_name from brwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM brwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'bs', user_name from bswiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM bswiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ca', user_name from cawiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM cawiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ceb', user_name from cebwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM cebwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ce', user_name from cewiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM cewiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ckb', user_name from ckbwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM ckbwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'crh', user_name from crhwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM crhwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'cv', user_name from cvwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM cvwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'cy', user_name from cywiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM cywiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'da', user_name from dawiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM dawiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'diq', user_name from diqwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM diqwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'dty', user_name from dtywiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM dtywiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'dv', user_name from dvwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM dvwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'el', user_name from elwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM elwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'eml', user_name from emlwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM emlwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'eo', user_name from eowiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM eowiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'et', user_name from etwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM etwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'eu', user_name from euwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM euwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'fi', user_name from fiwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM fiwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'fj', user_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 'frp', user_name from frpwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM frpwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'frr', user_name from frrwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM frrwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'fy', user_name from fywiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM fywiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ga', user_name from gawiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM gawiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'glk', user_name from glkwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM glkwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'gl', user_name from glwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM glwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'gor', user_name from gorwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM gorwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'gu', user_name from guwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM guwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'hak', user_name from hakwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM hakwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ha', user_name from hawiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM hawiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'haw', user_name from hawwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM hawwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'hif', user_name from hifwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM hifwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'hr', user_name from hrwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM hrwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'hsb', user_name from hsbwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM hsbwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ht', user_name from htwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM htwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'hu', user_name from huwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM huwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'hy', user_name from hywiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM hywiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'hyw', user_name from hywwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM hywwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ia', user_name from iawiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM iawiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ie', user_name from iewiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM iewiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ig', user_name from igwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM igwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ilo', user_name from ilowiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM ilowiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'inh', user_name from inhwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM inhwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'io', user_name from iowiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM iowiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'is', user_name from iswiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM iswiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'jv', user_name from jvwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM jvwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'kab', user_name from kabwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM kabwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ka', user_name from kawiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM kawiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'kk', user_name from kkwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM kkwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'km', user_name from kmwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM kmwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'kn', user_name from knwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM knwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ku', user_name from kuwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM kuwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'kw', user_name from kwwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM kwwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ky', user_name from kywiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM kywiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'la', user_name from lawiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM lawiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'lb', user_name from lbwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM lbwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'lfn', user_name from lfnwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM lfnwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'lij', user_name from lijwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM lijwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'li', user_name from liwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM liwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'lmo', user_name from lmowiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM lmowiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'lo', user_name from lowiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM lowiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'lrc', user_name from lrcwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM lrcwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'lt', user_name from ltwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM ltwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'lv', user_name from lvwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM lvwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'mai', user_name from maiwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM maiwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'mhr', user_name from mhrwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM mhrwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'min', user_name from minwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM minwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'mk', user_name from mkwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM mkwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ml', user_name from mlwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM mlwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'mn', user_name from mnwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM mnwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'mrj', user_name from mrjwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM mrjwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'mr', user_name from mrwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM mrwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ms', user_name from mswiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM mswiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'mt', user_name from mtwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM mtwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'myv', user_name from myvwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM myvwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'my', user_name from mywiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM mywiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'mzn', user_name from mznwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM mznwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'nap', user_name from napwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM napwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'nds', user_name from ndswiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM ndswiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ne', user_name from newiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM newiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'nn', user_name from nnwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM nnwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'no', user_name from nowiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM nowiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'nrm', user_name from nrmwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM nrmwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'nv', user_name from nvwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM nvwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'oc', user_name from ocwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM ocwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'or', user_name from orwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM orwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'os', user_name from oswiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM oswiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'pap', user_name from papwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM papwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'pa', user_name from pawiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM pawiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'pms', user_name from pmswiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM pmswiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'pnb', user_name from pnbwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM pnbwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ps', user_name from pswiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM pswiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'qu', user_name from quwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM quwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'rm', user_name from rmwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM rmwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ro', user_name from rowiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM rowiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'rue', user_name from ruewiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM ruewiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'sah', user_name from sahwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM sahwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'sat', user_name from satwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM satwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'sa', user_name from sawiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM sawiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'sco', user_name from scowiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM scowiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'sc', user_name from scwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM scwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'sd', user_name from sdwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM sdwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'shn', user_name from shnwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM shnwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'sh', user_name from shwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM shwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'simple', user_name from simplewiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM simplewiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'si', user_name from siwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM siwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'sk', user_name from skwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM skwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'sl', user_name from slwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM slwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'sn', user_name from snwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM snwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'so', user_name from sowiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM sowiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'sq', user_name from sqwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM sqwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'sr', user_name from srwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM srwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'stq', user_name from stqwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM stqwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'su', user_name from suwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM suwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'sv', user_name from svwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM svwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'sw', user_name from swwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM swwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'szl', user_name from szlwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM szlwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'szy', user_name from szywiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM szywiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ta', user_name from tawiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM tawiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'tcy', user_name from tcywiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM tcywiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'te', user_name from tewiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM tewiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'tg', user_name from tgwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM tgwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'th', user_name from thwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM thwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'tk', user_name from tkwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM tkwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'tl', user_name from tlwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM tlwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'tt', user_name from ttwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM ttwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'tyv', user_name from tyvwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM tyvwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'ur', user_name from urwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM urwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'uz', user_name from uzwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM uzwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'vec', user_name from vecwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM vecwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'vep', user_name from vepwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM vepwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'vo', user_name from vowiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM vowiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'war', user_name from warwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM warwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'wa', user_name from wawiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM wawiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'wuu', user_name from wuuwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM wuuwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'xmf', user_name from xmfwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM xmfwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'yi', user_name from yiwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM yiwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'yo', user_name from yowiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM yowiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'zh-classical', user_name from zh_classicalwiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM zh_classicalwiki_p.user_groups WHERE ug_group = 'bot') UNION
SELECT 'zh-yue', user_name from zh_yuewiki_p.user WHERE user_editcount > 100 AND user_id NOT IN (SELECT ug_user FROM zh_yuewiki_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])(.*)"
) AS C GROUP BY first, second
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query Stop Query
All SQL code is licensed under CC0 License.
SQL

Checking query status...
