Users who have signed COLOR or not

SQL

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" );
SQL

Checking query status...
