mysql:research@s3-analytics-slave [mediawikiwiki]> SELECT * FROM thread_history WHERE th_user_text = 'Ecliptica';
Empty set (0.94 sec)

mysql:research@s3-analytics-slave [mediawikiwiki]> SELECT * FROM thread_reaction WHERE tr_user_text = 'Ecliptica';
Empty set (0.00 sec)

mysql:wikiadmin@db1038 [mediawikiwiki]> UPDATE thread SET thread_author_name = 'Entropy' WHERE thread_author_name = 'Ecliptica';
Query OK, 2 rows affected (0.15 sec)
Rows matched: 2  Changed: 2  Warnings: 0

MariaDB [testwiki]>SELECT DISTINCT thread_author_name, user_name 
FROM thread LEFT OUTER JOIN user 
 ON thread_author_name = user_name 
WHERE user_name IS NULL 
 AND thread_author_name NOT REGEXP '^[0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3}$' 
 AND thread_author_name NOT REGEXP '^[0-9A-F]*.*:([0-9A-F])*$' ;

1225 rows in set (0.05 sec)

MariaDB [testwiki]> SELECT page_namespace, page_title, rev_user_text, user_name 
FROM page JOIN revision ON page_id = rev_page LEFT OUTER JOIN user 
 ON rev_user_text = user_name 
WHERE user_name IS NULL 
 AND rev_user_text NOT REGEXP '^[0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3}$' 
 AND rev_user_text NOT REGEXP '^[0-9A-F]*.*:([0-9A-F])*$' AND ( ( page_namespace = 4 
 AND page_title = 'Support_desk' ) OR ( page_namespace = 0 
 AND page_title = 'VisualEditor/Feedback' ) OR page_namespace IN ( 90, 91, 92, 93 ) ) LIMIT 100;

2 rows in set (0.01 sec)

MariaDB [testwiki]>  SELECT DISTINCT th_user_text, user_name 
FROM thread_history 
LEFT OUTER JOIN user ON th_user_text = user_name
WHERE user_name IS NULL 
 AND th_user_text NOT REGEXP '^[0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3}$' 
 AND th_user_text NOT REGEXP '^[0-9A-F]*.*:([0-9A-F])*$' ;

1242 rows in set (0.15 sec)

MariaDB [testwiki]> SELECT tr_user_text, user_name 
FROM thread_reaction 
LEFT OUTER JOIN user ON tr_user_text = user_name 
WHERE user_name IS NULL 
 AND tr_user_text NOT REGEXP '^[0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3}$' 
 AND tr_user_text NOT REGEXP '^[0-9A-F]*.*:([0-9A-F])*$' LIMIT 100;

Empty set (0.00 sec)

MariaDB [testwiki]> SELECT DISTINCT thread_author_name  
FROM thread 
WHERE thread_author_name NOT IN (select rev_user_text from revision) 
AND thread_author_name NOT REGEXP '^[0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3}$' AND thread_author_name NOT REGEXP '^[0-9A-F]*.*:([0-9A-F])*$' ;

1253 rows in set (0.04 sec)