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
AkatsukiRinn
.
Toggle Highlighting
SQL
SELECT user_id, user_registration, user_editcount FROM user WHERE timestampdiff(MONTH, user_registration, '2007-06-10 03:58:59') < 6 and user_id NOT IN (SELECT DISTINCT ufg_user FROM user_former_groups); SELECT potentially_ma user_registration, '2007-11-18 04:04:44') < 6 and user_id NOT IN (SELECT DISTINCT ufg_user FROM user_former_groups); SELECT potentially_matched.user_id, potentially_matched.user_registration, potentially_matched.user_editcount, COUNT(*) FROM (SELECT user.user_id, user.user_registration, user.user_editcount, user_former_groups.ufg_group FROM user right join user_former_groups on user.user_id = user_former_groups.ufg_user where timestampdiff(MONTH, user.user_registration, '2005-05-30 14:00:48') < 6 and user_former_groups.ufg_group IN ('sysop') and user_former_groups.ufg_group != 'bot') as potentially_matched right join user_former_groups on potentially_matched.user_id = user_former_groups.ufg_user GROUP BY potentially_matched.user_id, potentially_matched.user_registration HAVING COUNT(*) = 1; SELECT potentially_matched.user_id, potentially_matched.user_registration, potentially_matched.user_editcount, COUNT(*) FROM (SELECT user.user_id, user.user_registration, user.user_editcount, user_former_groups.ufg_group FROM user right join user_former_groups on user.user_id = user_former_groups.ufg_user where timestampdiff(MONTH, user.user_registration, '2004-12-23 23:48:16') < 6 and user_former_groups.ufg_group IN ('autoreviewer','extendedconfirmed','reviewer','rollbacker') and user_former_groups.ufg_group != 'bot') as potentially_matched right join user_former_groups on potentially_matched.user_id = user_former_groups.ufg_user GROUP BY potentially_matched.user_id, potentially_matched.user_registration HAVING COUNT(*) = 4; SELECT potentially_matched.user_id, potentially_matched.user_registration, potentially_matched.user_editcount, COUNT(*) FROM (SELECT user.user_id, user.user_registration, user.user_editcount, user_former_groups.ufg_group FROM user right join user_former_groups on user.user_id = user_former_groups.ufg_user where timestampdiff(MONTH, user.user_registration, '2006-01-05 02:29:51') < 6 and user_former_groups.ufg_group IN ('autoreviewer','extendedconfirmed','extendedmover','filemover','patroller','reviewer','rollbacker','templateeditor') and user_former_groups.ufg_group != 'bot') as potentially_matched right join user_former_groups on potentially_matched.user_id = user_former_groups.ufg_user GROUP BY potentially_matched.user_id, potentially_matched.user_registration HAVING COUNT(*) = 8; SELECT potentially_matched.user_id, potentially_matched.user_registration, potentially_matched.user_editcount, COUNT(*) FROM (SELECT user.user_id, user.user_registration, user.user_editcount, user_former_groups.ufg_group FROM user right join user_former_groups on user.user_id = user_former_groups.ufg_user where timestampdiff(MONTH, user.user_registration, '2006-09-22 13:55:45') < 6 and user_former_groups.ufg_group IN ('sysop') and user_former_groups.ufg_group != 'bot') as potentially_matched right join user_former_groups on potentially_matched.user_id = user_former_groups.ufg_user GROUP BY potentially_matched.user_id, potentially_matched.user_registration HAVING COUNT(*) = 1; SELECT potentially_matched.user_id, potentially_matched.user_registration, potentially_matched.user_editcount, COUNT(*) FROM (SELECT user.user_id, user.user_registration, user.user_editcount, user_former_groups.ufg_group FROM user right join user_former_groups on user.user_id = user_former_groups.ufg_user where timestampdiff(MONTH, user.user_registration, '2005-07-23 18:33:48') < 6 and user_former_groups.ufg_group IN ('extendedconfirmed') and user_former_groups.ufg_group != 'bot') as potentially_matched right join user_former_groups on potentially_matched.user_id = user_former_groups.ufg_user GROUP BY potentially_matched.user_id, potentially_matched.user_registration HAVING COUNT(*) = 1; SELECT potentially_matched.user_id, potentially_matched.user_registration, potentially_matched.user_editcount, COUNT(*) FROM (SELECT user.user_id, user.user_registration, user.user_editcount, user_former_groups.ufg_group FROM user right join user_former_groups on user.user_id = user_former_groups.ufg_user where timestampdiff(MONTH, user.user_registration, '2007-02-13 13:58:06') < 6 and user_former_groups.ufg_group IN ('extendedconfirmed') and user_former_groups.ufg_group != 'bot') as potentially_matched right join user_former_groups on potentially_matched.user_id = user_former_groups.ufg_user GROUP BY potentially_matched.user_id, potentially_matched.user_registration HAVING COUNT(*) = 1; SELECT potentially_matched.user_id, potentially_matched.user_registration, potentially_matched.user_editcount, COUNT(*) FROM (SELECT user.user_id, user.user_registration, user.user_editcount, user_former_groups.ufg_group FROM user right join user_former_groups on user.user_id = user_former_groups.ufg_user where timestampdiff(MONTH, user.user_registration, '2006-04-25 20:41:34') < 6 and user_former_groups.ufg_group IN ('extendedconfirmed') and user_former_groups.ufg_group != 'bot') as potentially_matched right join user_former_groups on potentially_matched.user_id = user_former_groups.ufg_user GROUP BY potentially_matched.user_id, potentially_matched.user_registration HAVING COUNT(*) = 1; SELECT user_id, user_registration, user_editcount FROM user WHERE timestampdiff(MONTH, user_registration, '2004-12-02 09:00:23') < 6 and user_id NOT IN (SELECT DISTINCT ufg_user FROM user_former_groups); SELECT user_id, user_registration, user_editcount FROM user WHERE timestampdiff(MONTH, user_registration, '2006-03-03 13:37:35') < 6 and user_id NOT IN (SELECT DISTINCT ufg_user FROM user_former_groups); SELECT user_id, user_registration, user_editcount FROM user WHERE timestampdiff(MONTH, user_registration, '2006-10-20 20:07:35') < 6 and user_id NOT IN (SELECT DISTINCT ufg_user FROM user_former_groups); SELECT potentially_matched.user_id, potentially_matched.user_registration, potentially_matched.user_editcount, COUNT(*) FROM (SELECT user.user_id, user.user_registration, user.user_editcount, user_former_groups.ufg_group FROM user right join user_former_groups on user.user_id = user_former_groups.ufg_user where timestampdiff(MONTH, user.user_registration, '2006-06-26 14:15:07') < 6 and user_former_groups.ufg_group IN ('autoreviewer','extendedconfirmed','reviewer','rollbacker') and user_former_groups.ufg_group != 'bot') as potentially_matched right join user_former_groups on potentially_matched.user_id = user_former_groups.ufg_user GROUP BY potentially_matched.user_id, potentially_matched.user_registration HAVING COUNT(*) = 4; SELECT potentially_matched.user_id, potentially_matched.user_registration, potentially_matched.user_editcount, COUNT(*) FROM (SELECT user.user_id, user.user_registration, user.user_editcount, user_former_groups.ufg_group FROM user right join user_former_groups on user.user_id = user_former_groups.ufg_user where timestampdiff(MONTH, user.user_registration, '2010-08-28 02:31:48') < 6 and user_former_groups.ufg_group IN ('accountcreator','extendedconfirmed','reviewer','rollbacker') and user_former_groups.ufg_group != 'bot') as potentially_matched right join user_former_groups on potentially_matched.user_id = user_former_groups.ufg_user GROUP BY potentially_matched.user_id, potentially_matched.user_registration HAVING COUNT(*) = 4; SELECT potentially_matched.user_id, potentially_matched.user_registration, potentially_matched.user_editcount, COUNT(*) FROM (SELECT user.user_id, user.user_registration, user.user_editcount, user_former_groups.ufg_group FROM user right join user_former_groups on user.user_id = user_former_groups.ufg_user where timestampdiff(MONTH, user.user_registration, '2003-08-07 06:52:27') < 6 and user_former_groups.ufg_group IN ('extendedconfirmed','reviewer') and user_former_groups.ufg_group != 'bot') as potentially_matched right join user_former_groups on potentially_matched.user_id = user_former_groups.ufg_user GROUP BY potentially_matched.user_id, potentially_matched.user_registration HAVING COUNT(*) = 2; SELECT user_id, user_registration, user_editcount FROM user WHERE timestampdiff(MONTH, user_registration, '2009-01-18 17:23:52') < 6 and user_id NOT IN (SELECT DISTINCT ufg_user FROM user_former_groups); SELECT potentially_matched.user_id, potentially_matched.user_registration, potentially_matched.user_editcount, COUNT(*) FROM (SELECT user.user_id, user.user_registration, user.user_editcount, user_former_groups.ufg_group FROM user right join user_former_groups on user.user_id = user_former_groups.ufg_user where timestampdiff(MONTH, user.user_registration, '2008-08-04 20:22:25') < 6 and user_former_groups.ufg_group IN ('extendedconfirmed') and user_former_groups.ufg_group != 'bot') as potentially_matched right join user_former_groups on potentially_matched.user_id = user_former_groups.ufg_user GROUP BY potentially_matched.user_id, potentially_matched.user_registration HAVING COUNT(*) = 1; SELECT potentially_matched.user_id, potentially_matched.user_registration, potentially_matched.user_editcount, COUNT(*) FROM (SELECT user.user_id, user.user_registration, user.user_editcount, user_former_groups.ufg_group FROM user right join user_former_groups on user.user_id = user_former_groups.ufg_user where timestampdiff(MONTH, user.user_registration, '2004-01-31 19:01:10') < 6 and user_former_groups.ufg_group IN ('autoreviewer','reviewer') and user_former_groups.ufg_group != 'bot') as potentially_matched right join user_former_groups on potentially_matched.user_id = user_former_groups.ufg_user GROUP BY potentially_matched.user_id, potentially_matched.user_registration HAVING COUNT(*) = 2; SELECT user_id, user_registration, user_editcount FROM user WHERE timestampdiff(MONTH, user_registration, '2005-10-12 08:07:38') < 6 and user_id NOT IN (SELECT DISTINCT ufg_user FROM user_former_groups); SELECT potentially_matched.user_id, potentially_matched.user_registration, potentially_matched.user_editcount, COUNT(*) FROM (SELECT user.user_id, user.user_registration, user.user_editcount, user_former_groups.ufg_group FROM user right join user_former_groups on user.user_id = user_former_groups.ufg_user where timestampdiff(MONTH, user.user_registration, '2004-11-25 02:52:55') < 6 and user_former_groups.ufg_group IN ('extendedconfirmed','rollbacker') and user_former_groups.ufg_group != 'bot') as potentially_matched right join user_former_groups on potentially_matched.user_id = user_former_groups.ufg_user GROUP BY potentially_matched.user_id, potentially_matched.user_registration HAVING COUNT(*) = 2; SELECT potentially_matched.user_id, potentially_matched.user_registration, potentially_matched.user_editcount, COUNT(*) FROM (SELECT user.user_id, user.user_registration, user.user_editcount, user_former_groups.ufg_group FROM user right join user_former_groups on user.user_id = user_former_groups.ufg_user where timestampdiff(MONTH, user.user_registration, '2004-01-01 07:52:10') < 6 and user_former_groups.ufg_group IN ('extendedconfirmed') and user_former_groups.ufg_group != 'bot') as potentially_matched right join user_former_groups on potentially_matched.user_id = user_former_groups.ufg_user GROUP BY potentially_matched.user_id, potentially_matched.user_registration HAVING COUNT(*) = 1; SELECT user_id, user_registration, user_editcount FROM user WHERE timestampdiff(MONTH, user_registration, '2007-03-18 02:36:20') < 6 and user_id NOT IN (SELECT DISTINCT ufg_user FROM user_former_groups); SELECT potentially_matched.user_id, potentially_matched.user_registration, potentially_matched.user_editcount, COUNT(*) FROM (SELECT user.user_id, user.user_registration, user.user_editcount, user_former_groups.ufg_group FROM user right join user_former_groups on user.user_id = user_former_groups.ufg_user where timestampdiff(MONTH, user.user_registration, '2003-08-03 16:31:39') < 6 and user_former_groups.ufg_group IN ('abusefilter','sysop') and user_former_groups.ufg_group != 'bot') as potentially_matched right join user_former_groups on potentially_matched.user_id = user_former_groups.ufg_user GROUP BY potentially_matched.user_id, potentially_matched.user_registration HAVING COUNT(*) = 2;
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...