MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table quests (
  id int,
  name varchar(20),
  `text` varchar(20),
  `date` int
);

insert into quests values
(1, 'Quest 1', 'Quest 1 Text', 1702570100),
(2, 'Quest 2', 'Quest 2 Text', 1702570120 );

create table answers (
  id int,
  quest_id  int,
  `text` varchar(20),
  `date` int
);

insert into answers values
(1,         1, 'Answer 1',                    1702570135),
(2,         1, 'Answer 2',                    1702570136),
(3,         2, 'Answer 1',                    1702570137),
(4,         2, 'Answer 2',                    1702570138),
(5,         2, 'Answer 3',                    1702570139);

Records: 2  Duplicates: 0  Warnings: 0



Records: 5  Duplicates: 0  Warnings: 0


SELECT quest_id, MAX(date) AS latest_date
FROM answers
GROUP BY quest_id


quest_id
latest_date


1
1702570136

2
1702570139


SELECT q.name AS Question, a.text AS answer
FROM quests AS q
INNER JOIN answers a ON a.quest_id = q.id
INNER JOIN (
  SELECT quest_id, MAX(date) AS latest_date
  FROM answers
  GROUP BY quest_id
) AS s on s.quest_id = a.quest_id and a.`date` = s.latest_date
ORDER BY q.id DESC
LIMIT 5


Question
answer


Quest 2
Answer 3

Quest 1
Answer 2