What query is needed here for the mysql table?

Question

MySQL

There are three tables:
joxi.ru/DrlQnngUv8Odkm
What query should I write to display selected products of a particular user (with id 1, for example)?

Answer 1

SELECT p.*
FROM users u
JOIN favorites f ON f.userid = u.id
JOIN products p ON p.id = f.videoid
WHERE u.id = 1