So I've done some research to recover some messages, but the only answer ive gotten isnt helping entirely. Ive found the command,
SELECT datetime (message.date / 1000000000 + strftime ("%s", "2001-01-01"), "unixepoch", "localtime") AS message_date, message.text, message.is_from_me, chat.chat_identifier
BUT, I don't need files from that folder. I need files from the chat folder itself. Not "chat_message_join"
I can see the phone number i want to view and everything in the browse data folder, but its the issue of reading the message content that i cant solve. Thank you anyone who can help.