MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE history (userid INTEGER, name VARCHAR(21), image VARCHAR(20), time DATETIME);

INSERT INTO history (userid, name, image, time) VALUES
  ('6', 'Arcade Mathematicians', 'arcadeMathematicians', '2021-04-17 07:59:00'),
  ('6', 'Arcade Mathematicians', 'arcadeMathematicians', '2021-04-17 08:01:04'),
  ('6', 'Infinite Spinner', 'infiniteSpinner', '2021-04-17 08:01:08'),
  ('6', 'Arcade Mathematicians', 'arcadeMathematicians', '2021-04-17 08:01:12'),
  ('6', 'Arcade Mathematicians', 'arcadeMathematicians', '2021-04-17 08:02:13'),
  ('6', 'Infinite Spinner', 'infiniteSpinner', '2021-04-17 08:02:16'),
  ('6', 'Arcade Mathematicians', 'arcadeMathematicians', '2021-04-17 08:03:16'),
  ('6', 'Infinite Spinner', 'infiniteSpinner', '2021-04-17 08:03:18'),
  ('6', 'Arcade Mathematicians', 'arcadeMathematicians', '2021-04-17 08:03:21');
WITH 
  cte1 AS (
    SELECT *, ROW_NUMBER() OVER (PARTITION BY userid, name ORDER BY time DESC) rn1
    FROM history
  ),
  cte2 AS (
    SELECT *, ROW_NUMBER() OVER (PARTITION BY userid ORDER BY time DESC) rn2
    FROM cte1
    WHERE rn1 = 1
  )
SELECT userid, name, image, time 
FROM cte2
WHERE rn2 <= 5 


userid
name
image
time


6
Arcade Mathematicians
arcadeMathematicians
2021-04-17 08:03:21

6
Infinite Spinner
infiniteSpinner
2021-04-17 08:03:18


SELECT DISTINCT userid, name, image, 
       MAX(time) OVER (PARTITION BY name) time 
FROM history
WHERE userid = 6
ORDER BY time DESC LIMIT 5


userid
name
image
time


6
Arcade Mathematicians
arcadeMathematicians
2021-04-17 08:03:21

6
Infinite Spinner
infiniteSpinner
2021-04-17 08:03:18


SELECT DISTINCT userid, name, 
       FIRST_VALUE(image) OVER (PARTITION BY name ORDER BY time DESC) image, 
       MAX(time) OVER (PARTITION BY name) time 
FROM history
WHERE userid = 6
ORDER BY time DESC LIMIT 5


userid
name
image
time


6
Arcade Mathematicians
arcadeMathematicians
2021-04-17 08:03:21

6
Infinite Spinner
infiniteSpinner
2021-04-17 08:03:18

userid	name	image	time
6	Arcade Mathematicians	arcadeMathematicians	2021-04-17 08:03:21
6	Infinite Spinner	infiniteSpinner	2021-04-17 08:03:18