Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Yair rand
.
Toggle Highlighting
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 'ab' AS 'ws', user_name AS 'name' from abwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM abwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ace', user_name from acewiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM acewiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ady', user_name from adywiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM adywiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'af', user_name from afwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM afwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ak', user_name from akwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM akwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'gsw', user_name from alswiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM alswiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'am', user_name from amwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM amwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ang', user_name from angwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM angwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'an', user_name from anwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM anwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'arc', user_name from arcwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM arcwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ary', user_name from arywiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM arywiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'arz', user_name from arzwiki_p.user WHERE user_editcount > 200 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 > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM aswiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'atj', user_name from atjwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM atjwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'avk', user_name from avkwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM avkwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'av', user_name from avwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM avwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'awa', user_name from awawiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM awawiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ay', user_name from aywiki_p.user WHERE user_editcount > 200 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 > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM azwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ban', user_name from banwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM banwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'bar', user_name from barwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM barwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'sgs', user_name from bat_smgwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM bat_smgwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ba', user_name from bawiki_p.user WHERE user_editcount > 200 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 > 200 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 > 200 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 > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM bgwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'bho', user_name from bhwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM bhwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'bi', user_name from biwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM biwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'bjn', user_name from bjnwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM bjnwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'bm', user_name from bmwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM bmwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'bo', user_name from bowiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM bowiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'bpy', user_name from bpywiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM bpywiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'br', user_name from brwiki_p.user WHERE user_editcount > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM bswiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'bug', user_name from bugwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM bugwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'bxr', user_name from bxrwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM bxrwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ca', user_name from cawiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM cawiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'cbk-zam', user_name from cbk_zamwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM cbk_zamwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'cdo', user_name from cdowiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM cdowiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ceb', user_name from cebwiki_p.user WHERE user_editcount > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM cewiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'chr', user_name from chrwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM chrwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ch', user_name from chwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM chwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'chy', user_name from chywiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM chywiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ckb', user_name from ckbwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM ckbwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'co', user_name from cowiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM cowiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'crh', user_name from crhwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM crhwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'cr', user_name from crwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM crwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'csb', user_name from csbwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM csbwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'cu', user_name from cuwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM cuwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'cv', user_name from cvwiki_p.user WHERE user_editcount > 200 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 > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM dawiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'din', user_name from dinwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM dinwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'diq', user_name from diqwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM diqwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'dsb', user_name from dsbwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM dsbwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'dty', user_name from dtywiki_p.user WHERE user_editcount > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM dvwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'dz', user_name from dzwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM dzwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ee', user_name from eewiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM eewiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'el', user_name from elwiki_p.user WHERE user_editcount > 200 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 > 200 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 > 200 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 > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM euwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ext', user_name from extwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM extwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ff', user_name from ffwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM ffwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'vro', user_name from fiu_vrowiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM fiu_vrowiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'fi', user_name from fiwiki_p.user WHERE user_editcount > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM fjwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'fo', user_name from fowiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM fowiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'frp', user_name from frpwiki_p.user WHERE user_editcount > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM frrwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'fur', user_name from furwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM furwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'fy', user_name from fywiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM fywiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'gag', user_name from gagwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM gagwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'gan', user_name from ganwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM ganwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ga', user_name from gawiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM gawiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'gcr', user_name from gcrwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM gcrwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'gd', user_name from gdwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM gdwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'glk', user_name from glkwiki_p.user WHERE user_editcount > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM glwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'gn', user_name from gnwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM gnwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'gom', user_name from gomwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM gomwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'gor', user_name from gorwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM gorwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'got', user_name from gotwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM gotwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'gu', user_name from guwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM guwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'gv', user_name from gvwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM gvwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'hak', user_name from hakwiki_p.user WHERE user_editcount > 200 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 > 200 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 > 200 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 > 200 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 > 200 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 > 200 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 > 200 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 > 200 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 > 200 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 > 200 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 > 200 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 > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM igwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ik', user_name from ikwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM ikwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ilo', user_name from ilowiki_p.user WHERE user_editcount > 200 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 > 200 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 > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM iswiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'iu', user_name from iuwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM iuwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'jam', user_name from jamwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM jamwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'jbo', user_name from jbowiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM jbowiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'jv', user_name from jvwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM jvwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'kaa', user_name from kaawiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM kaawiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'kab', user_name from kabwiki_p.user WHERE user_editcount > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM kawiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'kbd', user_name from kbdwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM kbdwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'kbp', user_name from kbpwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM kbpwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'kg', user_name from kgwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM kgwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ki', user_name from kiwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM kiwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'kk', user_name from kkwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM kkwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'kl', user_name from klwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM klwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'km', user_name from kmwiki_p.user WHERE user_editcount > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM knwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'koi', user_name from koiwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM koiwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'krc', user_name from krcwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM krcwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ksh', user_name from kshwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM kshwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ks', user_name from kswiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM kswiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ku', user_name from kuwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM kuwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'kv', user_name from kvwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM kvwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'kw', user_name from kwwiki_p.user WHERE user_editcount > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM kywiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'lad', user_name from ladwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM ladwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'la', user_name from lawiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM lawiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'lbe', user_name from lbewiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM lbewiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'lb', user_name from lbwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM lbwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'lez', user_name from lezwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM lezwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'lfn', user_name from lfnwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM lfnwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'lg', user_name from lgwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM lgwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'lij', user_name from lijwiki_p.user WHERE user_editcount > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM liwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'lld', user_name from lldwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM lldwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'lmo', user_name from lmowiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM lmowiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ln', user_name from lnwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM lnwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'lo', user_name from lowiki_p.user WHERE user_editcount > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM lrcwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ltg', user_name from ltgwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM ltgwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'lt', user_name from ltwiki_p.user WHERE user_editcount > 200 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 > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM maiwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'map-bms', user_name from map_bmswiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM map_bmswiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'mdf', user_name from mdfwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM mdfwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'mg', user_name from mgwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM mgwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'mhr', user_name from mhrwiki_p.user WHERE user_editcount > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM minwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'mi', user_name from miwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM miwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'mk', user_name from mkwiki_p.user WHERE user_editcount > 200 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 > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM mnwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'mnw', user_name from mnwwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM mnwwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'mrj', user_name from mrjwiki_p.user WHERE user_editcount > 200 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 > 200 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 > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM mtwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'mwl', user_name from mwlwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM mwlwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'myv', user_name from myvwiki_p.user WHERE user_editcount > 200 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 > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM mznwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'nah', user_name from nahwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM nahwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'nap', user_name from napwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM napwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'na', user_name from nawiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM nawiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'nds', user_name from ndswiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM ndswiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'nds-nl', user_name from nds_nlwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM nds_nlwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ne', user_name from newiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM newiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'new', user_name from newwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM newwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'nn', user_name from nnwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM nnwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'nov', user_name from novwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM novwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'nb', user_name from nowiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM nowiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'nqo', user_name from nqowiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM nqowiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'nrm', user_name from nrmwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM nrmwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'nso', user_name from nsowiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM nsowiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'nv', user_name from nvwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM nvwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ny', user_name from nywiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM nywiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'oc', user_name from ocwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM ocwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'olo', user_name from olowiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM olowiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'om', user_name from omwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM omwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'or', user_name from orwiki_p.user WHERE user_editcount > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM oswiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'pag', user_name from pagwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM pagwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'pam', user_name from pamwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM pamwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'pap', user_name from papwiki_p.user WHERE user_editcount > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM pawiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'pcd', user_name from pcdwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM pcdwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'pdc', user_name from pdcwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM pdcwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'pfl', user_name from pflwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM pflwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'pih', user_name from pihwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM pihwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'pi', user_name from piwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM piwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'pms', user_name from pmswiki_p.user WHERE user_editcount > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM pnbwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'pnt', user_name from pntwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM pntwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ps', user_name from pswiki_p.user WHERE user_editcount > 200 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 > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM rmwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'rmy', user_name from rmywiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM rmywiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'rn', user_name from rnwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM rnwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'rup', user_name from roa_rupwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM roa_rupwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'roa-tara', user_name from roa_tarawiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM roa_tarawiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ro', user_name from rowiki_p.user WHERE user_editcount > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM ruewiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'rw', user_name from rwwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM rwwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'sah', user_name from sahwiki_p.user WHERE user_editcount > 200 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 > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM sawiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'scn', user_name from scnwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM scnwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'sco', user_name from scowiki_p.user WHERE user_editcount > 200 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 > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM sdwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'se', user_name from sewiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM sewiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'sg', user_name from sgwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM sgwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'shn', user_name from shnwiki_p.user WHERE user_editcount > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM shwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'si', user_name from siwiki_p.user WHERE user_editcount > 200 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 > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM slwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'smn', user_name from smnwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM smnwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'sm', user_name from smwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM smwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'sn', user_name from snwiki_p.user WHERE user_editcount > 200 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 > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM sqwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'srn', user_name from srnwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM srnwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'sr', user_name from srwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM srwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ss', user_name from sswiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM sswiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'stq', user_name from stqwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM stqwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'st', user_name from stwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM stwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'su', user_name from suwiki_p.user WHERE user_editcount > 200 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 > 200 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 > 200 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 > 200 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 > 200 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 > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM tcywiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'tet', user_name from tetwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM tetwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'te', user_name from tewiki_p.user WHERE user_editcount > 200 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 > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM thwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ti', user_name from tiwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM tiwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'tk', user_name from tkwiki_p.user WHERE user_editcount > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM tlwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'tn', user_name from tnwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM tnwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'to', user_name from towiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM towiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'tpi', user_name from tpiwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM tpiwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ts', user_name from tswiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM tswiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'tt', user_name from ttwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM ttwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'tum', user_name from tumwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM tumwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'tw', user_name from twwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM twwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'tyv', user_name from tyvwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM tyvwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ty', user_name from tywiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM tywiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'udm', user_name from udmwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM udmwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ug', user_name from ugwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM ugwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ur', user_name from urwiki_p.user WHERE user_editcount > 200 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 > 200 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 > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM vepwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 've', user_name from vewiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM vewiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'vls', user_name from vlswiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM vlswiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'vo', user_name from vowiki_p.user WHERE user_editcount > 200 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 > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM wawiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'wo', user_name from wowiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM wowiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'wuu', user_name from wuuwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM wuuwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'xal', user_name from xalwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM xalwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'xh', user_name from xhwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM xhwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'xmf', user_name from xmfwiki_p.user WHERE user_editcount > 200 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 > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM yowiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'za', user_name from zawiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM zawiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'zea', user_name from zeawiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM zeawiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'lzh', user_name from zh_classicalwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM zh_classicalwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'nan', user_name from zh_min_nanwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM zh_min_nanwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'yue', user_name from zh_yuewiki_p.user WHERE user_editcount > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM zuwiki_p.user_groups WHERE ug_group = 'bot') ) A INNER JOIN ( SELECT 'ab' AS 'ws', user_name AS 'name' from abwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM abwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ace', user_name from acewiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM acewiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ady', user_name from adywiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM adywiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'af', user_name from afwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM afwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ak', user_name from akwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM akwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'gsw', user_name from alswiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM alswiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'am', user_name from amwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM amwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ang', user_name from angwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM angwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'an', user_name from anwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM anwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'arc', user_name from arcwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM arcwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ary', user_name from arywiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM arywiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'arz', user_name from arzwiki_p.user WHERE user_editcount > 200 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 > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM aswiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'atj', user_name from atjwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM atjwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'avk', user_name from avkwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM avkwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'av', user_name from avwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM avwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'awa', user_name from awawiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM awawiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ay', user_name from aywiki_p.user WHERE user_editcount > 200 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 > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM azwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ban', user_name from banwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM banwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'bar', user_name from barwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM barwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'sgs', user_name from bat_smgwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM bat_smgwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ba', user_name from bawiki_p.user WHERE user_editcount > 200 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 > 200 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 > 200 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 > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM bgwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'bho', user_name from bhwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM bhwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'bi', user_name from biwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM biwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'bjn', user_name from bjnwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM bjnwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'bm', user_name from bmwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM bmwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'bo', user_name from bowiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM bowiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'bpy', user_name from bpywiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM bpywiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'br', user_name from brwiki_p.user WHERE user_editcount > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM bswiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'bug', user_name from bugwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM bugwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'bxr', user_name from bxrwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM bxrwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ca', user_name from cawiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM cawiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'cbk-zam', user_name from cbk_zamwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM cbk_zamwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'cdo', user_name from cdowiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM cdowiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ceb', user_name from cebwiki_p.user WHERE user_editcount > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM cewiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'chr', user_name from chrwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM chrwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ch', user_name from chwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM chwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'chy', user_name from chywiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM chywiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ckb', user_name from ckbwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM ckbwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'co', user_name from cowiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM cowiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'crh', user_name from crhwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM crhwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'cr', user_name from crwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM crwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'csb', user_name from csbwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM csbwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'cu', user_name from cuwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM cuwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'cv', user_name from cvwiki_p.user WHERE user_editcount > 200 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 > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM dawiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'din', user_name from dinwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM dinwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'diq', user_name from diqwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM diqwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'dsb', user_name from dsbwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM dsbwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'dty', user_name from dtywiki_p.user WHERE user_editcount > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM dvwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'dz', user_name from dzwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM dzwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ee', user_name from eewiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM eewiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'el', user_name from elwiki_p.user WHERE user_editcount > 200 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 > 200 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 > 200 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 > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM euwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ext', user_name from extwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM extwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ff', user_name from ffwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM ffwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'vro', user_name from fiu_vrowiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM fiu_vrowiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'fi', user_name from fiwiki_p.user WHERE user_editcount > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM fjwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'fo', user_name from fowiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM fowiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'frp', user_name from frpwiki_p.user WHERE user_editcount > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM frrwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'fur', user_name from furwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM furwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'fy', user_name from fywiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM fywiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'gag', user_name from gagwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM gagwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'gan', user_name from ganwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM ganwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ga', user_name from gawiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM gawiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'gcr', user_name from gcrwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM gcrwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'gd', user_name from gdwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM gdwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'glk', user_name from glkwiki_p.user WHERE user_editcount > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM glwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'gn', user_name from gnwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM gnwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'gom', user_name from gomwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM gomwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'gor', user_name from gorwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM gorwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'got', user_name from gotwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM gotwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'gu', user_name from guwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM guwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'gv', user_name from gvwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM gvwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'hak', user_name from hakwiki_p.user WHERE user_editcount > 200 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 > 200 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 > 200 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 > 200 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 > 200 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 > 200 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 > 200 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 > 200 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 > 200 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 > 200 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 > 200 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 > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM igwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ik', user_name from ikwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM ikwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ilo', user_name from ilowiki_p.user WHERE user_editcount > 200 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 > 200 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 > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM iswiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'iu', user_name from iuwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM iuwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'jam', user_name from jamwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM jamwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'jbo', user_name from jbowiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM jbowiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'jv', user_name from jvwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM jvwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'kaa', user_name from kaawiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM kaawiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'kab', user_name from kabwiki_p.user WHERE user_editcount > 200 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 > 200 AND user_id NOT IN (SELECT ug_user FROM kawiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'kbd', user_name from kbdwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM kbdwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'kbp', user_name from kbpwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM kbpwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'kg', user_name from kgwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM kgwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'ki', user_name from kiwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM kiwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'kk', user_name from kkwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM kkwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'kl', user_name from klwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM klwiki_p.user_groups WHERE ug_group = 'bot') UNION SELECT 'km', user_name from kmwiki_p.user WHERE user_editcount > 200 AND user_id NOT IN (SELECT ug_user FROM kmwiki_p.user_groups
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
.
Checking query status...
