mysql> SELECT * FROM thread WHERE thread_author_name = 'Old username' LIMIT 10 \G *************************** 1. row *************************** thread_id: 11013 thread_root: 860 thread_ancestor: 0 thread_parent: NULL thread_summary_page: NULL thread_subject: New thread thread_author_id: 432 thread_author_name: Old username thread_modified: 20150717202302 thread_created: 20150717202145 thread_editedness: 1 thread_article_namespace: 0 thread_article_title: LQT_Rename_Test thread_article_id: 859 thread_type: 0 thread_sortkey: 20150717202302 thread_replies: 2 thread_signature: [[User:Old username|Old username]] ([[User talk:Old username|talk]]) *************************** 2. row *************************** thread_id: 11014 thread_root: 861 thread_ancestor: 11013 thread_parent: 11013 thread_summary_page: NULL thread_subject: New thread thread_author_id: 432 thread_author_name: Old username thread_modified: 20150717202302 thread_created: 20150717202153 thread_editedness: 2 thread_article_namespace: 0 thread_article_title: LQT_Rename_Test thread_article_id: 859 thread_type: 0 thread_sortkey: 20150717202302 thread_replies: 1 thread_signature: [[User:Old username|Old username]] ([[User talk:Old username|talk]]) *************************** 3. row *************************** thread_id: 11015 thread_root: 862 thread_ancestor: 11013 thread_parent: 11014 thread_summary_page: NULL thread_subject: New thread thread_author_id: 432 thread_author_name: Old username thread_modified: 20150717202203 thread_created: 20150717202203 thread_editedness: 0 thread_article_namespace: 0 thread_article_title: LQT_Rename_Test thread_article_id: 859 thread_type: 0 thread_sortkey: 20150717202203 thread_replies: 0 thread_signature: [[User:Old username|Old username]] ([[User talk:Old username|talk]]) 3 rows in set (0.02 sec) mysql> SELECT * FROM revision WHERE rev_user_text = 'Old username' LIMIT 10\G *************************** 1. row *************************** rev_id: 1797 rev_page: 860 rev_text_id: 1348 rev_comment: New thread: New thread rev_user: 432 rev_user_text: Old username rev_timestamp: 20150717202145 rev_minor_edit: 0 rev_deleted: 0 rev_len: 4 rev_parent_id: 0 rev_sha1: e22wovd8j8vhmq10h6bwfdx02okycwb rev_content_format: NULL rev_content_model: NULL *************************** 2. row *************************** rev_id: 1798 rev_page: 861 rev_text_id: 1349 rev_comment: Reply to [[Thread:LQT Rename Test/New thread|New thread]] rev_user: 432 rev_user_text: Old username rev_timestamp: 20150717202153 rev_minor_edit: 0 rev_deleted: 0 rev_len: 5 rev_parent_id: 0 rev_sha1: cmvob5khb95z6zw12kzyqs84pcvnp55 rev_content_format: NULL rev_content_model: NULL *************************** 3. row *************************** rev_id: 1799 rev_page: 862 rev_text_id: 1350 rev_comment: Reply to [[Thread:LQT Rename Test/New thread/reply|New thread]] rev_user: 432 rev_user_text: Old username rev_timestamp: 20150717202203 rev_minor_edit: 0 rev_deleted: 0 rev_len: 13 rev_parent_id: 0 rev_sha1: bx86uzhrqfjdmzkp0bedjz7yrh9rmcs rev_content_format: NULL rev_content_model: NULL *************************** 4. row *************************** rev_id: 1800 rev_page: 861 rev_text_id: 1351 rev_comment: rev_user: 432 rev_user_text: Old username rev_timestamp: 20150717202302 rev_minor_edit: 1 rev_deleted: 0 rev_len: 12 rev_parent_id: 1798 rev_sha1: rnienf2y4vqzi0akvoqhlo4q877mo8l rev_content_format: NULL rev_content_model: NULL 4 rows in set (0.00 sec) mysql> SELECT * FROM thread_history WHERE th_user_text = 'Old username' LIMIT 10\G *************************** 1. row *************************** th_id: 14285 th_thread: 11013 th_timestamp: 20150717202145 th_user: 432 th_user_text: Old username th_change_type: 0 th_change_object: 11013 th_change_comment: th_content: O:6:"Thread":26:{s:9:" * rootId";i:860;s:12:" * articleId";i:859;s:12:" * summaryId";N;s:13:" * ancestorId";i:0;s:11:" * parentId";N;s:14:" * superthread";N;s:11:" * ancestor";r:1;s:19:" * articleNamespace";i:0;s:15:" * articleTitle";s:15:"LQT_Rename_Test";s:11:" * modified";s:14:"20150717202145";s:10:" * created";s:14:"20150717202145";s:10:" * sortkey";s:14:"20150717202145";s:5:" * id";i:11013;s:7:" * type";i:0;s:10:" * subject";s:10:"New thread";s:11:" * authorId";i:432;s:13:" * authorName";s:12:"Old username";s:12:" * signature";s:68:"[[User:Old username|Old username]] ([[User talk:Old username|talk]])";s:16:" * allDataLoaded";N;s:15:" * isHistorical";b:0;s:15:" * rootRevision";N;s:10:"editedness";i:0;s:10:" * editors";N;s:10:" * replies";a:0:{}s:12:" * reactions";N;s:10:"replyCount";i:0;} *************************** 2. row *************************** th_id: 14286 th_thread: 11013 th_timestamp: 20150717202154 th_user: 432 th_user_text: Old username th_change_type: 1 th_change_object: 11014 th_change_comment: Reply to [[Thread:LQT Rename Test/New thread|New thread]] th_content: O:6:"Thread":26:{s:9:" * rootId";s:3:"860";s:12:" * articleId";s:3:"859";s:12:" * summaryId";N;s:13:" * ancestorId";s:1:"0";s:11:" * parentId";N;s:14:" * superthread";N;s:11:" * ancestor";r:1;s:19:" * articleNamespace";s:1:"0";s:15:" * articleTitle";s:15:"LQT_Rename_Test";s:11:" * modified";s:14:"20150717202154";s:10:" * created";s:14:"20150717202145";s:10:" * sortkey";s:14:"20150717202154";s:5:" * id";s:5:"11013";s:7:" * type";s:1:"0";s:10:" * subject";s:10:"New thread";s:11:" * authorId";s:3:"432";s:13:" * authorName";s:12:"Old username";s:12:" * signature";s:68:"[[User:Old username|Old username]] ([[User talk:Old username|talk]])";s:16:" * allDataLoaded";N;s:15:" * isHistorical";b:0;s:15:" * rootRevision";N;s:10:"editedness";i:1;s:10:" * editors";N;s:10:" * replies";a:1:{i:11014;O:6:"Thread":26:{s:9:" * rootId";i:861;s:12:" * articleId";i:859;s:12:" * summaryId";N;s:13:" * ancestorId";s:5:"11013";s:11:" * parentId";s:5:"11013";s:14:" * superthread";r:1;s:11:" * ancestor";r:1;s:19:" * articleNamespace";i:0;s:15:" * articleTitle";s:15:"LQT_Rename_Test";s:11:" * modified";s:14:"20150717202153";s:10:" * created";s:14:"20150717202153";s:10:" * sortkey";s:14:"20150717202153";s:5:" * id";i:11014;s:7:" * type";i:0;s:10:" * subject";s:10:"New thread";s:11:" * authorId";i:432;s:13:" * authorName";s:12:"Old username";s:12:" * signature";s:68:"[[User:Old username|Old username]] ([[User talk:Old username|talk]])";s:16:" * allDataLoaded";N;s:15:" * isHistorical";b:0;s:15:" * rootRevision";N;s:10:"editedness";i:0;s:10:" * editors";N;s:10:" * replies";a:0:{}s:12:" * reactions";N;s:10:"replyCount";i:0;}}s:12:" * reactions";N;s:10:"replyCount";i:1;} *************************** 3. row *************************** th_id: 14287 th_thread: 11013 th_timestamp: 20150717202203 th_user: 432 th_user_text: Old username th_change_type: 1 th_change_object: 11015 th_change_comment: Reply to [[Thread:LQT Rename Test/New thread/reply|New thread]] th_content: O:6:"Thread":26:{s:9:" * rootId";s:3:"860";s:12:" * articleId";s:3:"859";s:12:" * summaryId";N;s:13:" * ancestorId";s:1:"0";s:11:" * parentId";N;s:14:" * superthread";N;s:11:" * ancestor";r:1;s:19:" * articleNamespace";s:1:"0";s:15:" * articleTitle";s:15:"LQT_Rename_Test";s:11:" * modified";s:14:"20150717202203";s:10:" * created";s:14:"20150717202145";s:10:" * sortkey";s:14:"20150717202203";s:5:" * id";s:5:"11013";s:7:" * type";s:1:"0";s:10:" * subject";s:10:"New thread";s:11:" * authorId";s:3:"432";s:13:" * authorName";s:12:"Old username";s:12:" * signature";s:68:"[[User:Old username|Old username]] ([[User talk:Old username|talk]])";s:16:" * allDataLoaded";N;s:15:" * isHistorical";b:0;s:15:" * rootRevision";N;s:10:"editedness";s:1:"1";s:10:" * editors";N;s:10:" * replies";a:1:{i:11014;O:6:"Thread":26:{s:9:" * rootId";s:3:"861";s:12:" * articleId";s:3:"859";s:12:" * summaryId";N;s:13:" * ancestorId";s:5:"11013";s:11:" * parentId";s:5:"11013";s:14:" * superthread";r:1;s:11:" * ancestor";r:1;s:19:" * articleNamespace";s:1:"0";s:15:" * articleTitle";s:15:"LQT_Rename_Test";s:11:" * modified";s:14:"20150717202203";s:10:" * created";s:14:"20150717202153";s:10:" * sortkey";s:14:"20150717202203";s:5:" * id";s:5:"11014";s:7:" * type";s:1:"0";s:10:" * subject";s:10:"New thread";s:11:" * authorId";s:3:"432";s:13:" * authorName";s:12:"Old username";s:12:" * signature";s:68:"[[User:Old username|Old username]] ([[User talk:Old username|talk]])";s:16:" * allDataLoaded";N;s:15:" * isHistorical";b:0;s:15:" * rootRevision";N;s:10:"editedness";i:1;s:10:" * editors";N;s:10:" * replies";a:1:{i:11015;O:6:"Thread":26:{s:9:" * rootId";i:862;s:12:" * articleId";i:859;s:12:" * summaryId";N;s:13:" * ancestorId";s:5:"11013";s:11:" * parentId";s:5:"11014";s:14:" * superthread";r:26;s:11:" * ancestor";r:1;s:19:" * articleNamespace";i:0;s:15:" * articleTitle";s:15:"LQT_Rename_Test";s:11:" * modified";s:14:"20150717202203";s:10:" * created";s:14:"20150717202203";s:10:" * sortkey";s:14:"20150717202203";s:5:" * id";i:11015;s:7:" * type";i:0;s:10:" * subject";s:10:"New thread";s:11:" * authorId";i:432;s:13:" * authorName";s:12:"Old username";s:12:" * signature";s:68:"[[User:Old username|Old username]] ([[User talk:Old username|talk]])";s:16:" * allDataLoaded";N;s:15:" * isHistorical";b:0;s:15:" * rootRevision";N;s:10:"editedness";i:0;s:10:" * editors";N;s:10:" * replies";a:0:{}s:12:" * reactions";N;s:10:"replyCount";i:0;}}s:12:" * reactions";N;s:10:"replyCount";i:1;}}s:12:" * reactions";N;s:10:"replyCount";i:2;} *************************** 4. row *************************** th_id: 14288 th_thread: 11013 th_timestamp: 20150717202302 th_user: 432 th_user_text: Old username th_change_type: 2 th_change_object: 11014 th_change_comment: th_content: O:6:"Thread":26:{s:9:" * rootId";s:3:"860";s:12:" * articleId";s:3:"859";s:12:" * summaryId";N;s:13:" * ancestorId";s:1:"0";s:11:" * parentId";N;s:14:" * superthread";N;s:11:" * ancestor";r:1;s:19:" * articleNamespace";s:1:"0";s:15:" * articleTitle";s:15:"LQT_Rename_Test";s:11:" * modified";s:14:"20150717202302";s:10:" * created";s:14:"20150717202145";s:10:" * sortkey";s:14:"20150717202302";s:5:" * id";s:5:"11013";s:7:" * type";s:1:"0";s:10:" * subject";s:10:"New thread";s:11:" * authorId";s:3:"432";s:13:" * authorName";s:12:"Old username";s:12:" * signature";s:68:"[[User:Old username|Old username]] ([[User talk:Old username|talk]])";s:16:" * allDataLoaded";N;s:15:" * isHistorical";b:0;s:15:" * rootRevision";N;s:10:"editedness";s:1:"1";s:10:" * editors";N;s:10:" * replies";a:1:{i:11014;O:6:"Thread":26:{s:9:" * rootId";s:3:"861";s:12:" * articleId";s:3:"859";s:12:" * summaryId";N;s:13:" * ancestorId";s:5:"11013";s:11:" * parentId";s:5:"11013";s:14:" * superthread";r:1;s:11:" * ancestor";r:1;s:19:" * articleNamespace";s:1:"0";s:15:" * articleTitle";s:15:"LQT_Rename_Test";s:11:" * modified";s:14:"20150717202302";s:10:" * created";s:14:"20150717202153";s:10:" * sortkey";s:14:"20150717202302";s:5:" * id";s:5:"11014";s:7:" * type";s:1:"0";s:10:" * subject";s:10:"New thread";s:11:" * authorId";s:3:"432";s:13:" * authorName";s:12:"Old username";s:12:" * signature";s:68:"[[User:Old username|Old username]] ([[User talk:Old username|talk]])";s:16:" * allDataLoaded";N;s:15:" * isHistorical";b:0;s:15:" * rootRevision";N;s:10:"editedness";i:2;s:10:" * editors";N;s:10:" * replies";a:1:{i:11015;O:6:"Thread":26:{s:9:" * rootId";s:3:"862";s:12:" * articleId";s:3:"859";s:12:" * summaryId";N;s:13:" * ancestorId";s:5:"11013";s:11:" * parentId";s:5:"11014";s:14:" * superthread";r:26;s:11:" * ancestor";r:1;s:19:" * articleNamespace";s:1:"0";s:15:" * articleTitle";s:15:"LQT_Rename_Test";s:11:" * modified";s:14:"20150717202203";s:10:" * created";s:14:"20150717202203";s:10:" * sortkey";s:14:"20150717202203";s:5:" * id";s:5:"11015";s:7:" * type";s:1:"0";s:10:" * subject";s:10:"New thread";s:11:" * authorId";s:3:"432";s:13:" * authorName";s:12:"Old username";s:12:" * signature";s:68:"[[User:Old username|Old username]] ([[User talk:Old username|talk]])";s:16:" * allDataLoaded";N;s:15:" * isHistorical";b:0;s:15:" * rootRevision";N;s:10:"editedness";s:1:"0";s:10:" * editors";N;s:10:" * replies";a:0:{}s:12:" * reactions";N;s:10:"replyCount";s:1:"0";}}s:12:" * reactions";N;s:10:"replyCount";s:1:"1";}}s:12:" * reactions";N;s:10:"replyCount";s:1:"2";} 4 rows in set (0.03 sec) mysql> SELECT * FROM thread_reaction WHERE tr_user_text = 'Old username'; Empty set (0.00 sec)