Does this work for your needs? Executing SQL Queries in phpMyAdminD. K wrote: Fri Jan 17, 2025 4:07 pm None of us knows SQL but can follow a step by step example and do a query via phpMyAdmin
I have taken the liberty to make the column headings a bit more 'friendly'.
Code: Select all
SELECT phpbb_users.username as "User", FROM_UNIXTIME(save_time) as "Draft was saved", draft_subject as "Draft Subject"
FROM `phpbb_drafts`
INNER JOIN phpbb_users
ON phpbb_drafts.user_id=phpbb_users.user_id
ORDER by phpbb_drafts.user_id;