18 Sep
2023
18 Sep
'23
6:19 p.m.
And they do have the same thread_id as well:
select a.id, b.starting_email_id, a.message_id_hash, b.thread_id from hyperkitty_email a,hyperkitty_thread b where a.message_id_hash = b.thread_id and a.id = b.starting_email_id and a.id in (1365,1366) ;
id | starting_email_id | message_id_hash | thread_id
------+-------------------+----------------------------------+----------------------------------
1365 | 1365 | UB4WSRNRTPBH7XB6RF3W42U2MUDK77S7 | UB4WSRNRTPBH7XB6RF3W42U2MUDK77S7
1366 | 1366 | UB4WSRNRTPBH7XB6RF3W42U2MUDK77S7 | UB4WSRNRTPBH7XB6RF3W42U2MUDK77S7
(2 rows)