SQL
AخA
USE metawiki_p;
SELECT user_name
FROM user
LEFT JOIN ipblocks
ON user_id = ipb_user
JOIN centralauth_p.globaluser gu
ON user_name = gu.gu_name
AND gu.gu_locked = 0
WHERE user_editcount > 50
AND user_id NOT IN (
SELECT ug_user
FROM user_groups
WHERE ug_group = "bot"
)
AND LOWER(user_name) NOT LIKE '%bot%'
AND user_id NOT IN (
SELECT DISTINCT(user_id)
FROM page
JOIN revision
ON page_id = rev_page
AND page_title LIKE "Community_open_letter_on_renaming%"
JOIN actor_revision
ON rev_actor = actor_id
JOIN user
ON actor_user = user_id )
AND user_id IN (
SELECT DISTINCT(user_id)
FROM user
JOIN actor_revision
ON actor_user = user_id
JOIN revision_userindex
ON rev_actor = actor_id
AND rev_timestamp > "20100101000000" );
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.