mysql> SELECT * FROM thread WHERE thread_author_name = 'Old username' LIMIT 10 \G
Empty set (0.02 sec)
mysql> SELECT * FROM revision WHERE rev_user_text = 'Old username' LIMIT 10\G
Empty set (0.00 sec)
mysql> SELECT * FROM thread_history WHERE th_user_text = 'Old username' LIMIT 10\G
Empty set (0.08 sec)
mysql> SELECT * FROM thread_reaction WHERE tr_user_text = 'Old username';
Empty set (0.00 sec)
mysql>
mysql> SELECT * FROM thread WHERE thread_author_name = 'New 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: New 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: New 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: New 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 = 'New 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: New 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: New 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: New 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: New 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 = 'New username' LIMIT 10\G
*************************** 1. row ***************************
th_id: 14285
th_thread: 11013
th_timestamp: 20150717202145
th_user: 432
th_user_text: New 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: New 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: New 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: New 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.06 sec)
mysql> SELECT * FROM thread_reaction WHERE tr_user_text = 'New username';
Empty set (0.00 sec)