How to write such a SQL query?

Question

MySQL

I have 3 tables: users, articles and likes.

Their structures are:

users: id, ...
articles: id, author_id, ...
likes: article_id, user_id, liked

I need to write a SQL query to get all the articles of a given author_id, tagging those that the user with id X likes. That is, the response should contain data on ALL articles by the author author_id and the liked field which will be = 1 (if the user with id X liked this article) and 0 (if he did not like it).

I tried to do like this:

SELECT articles.id, articles.title, likes.liked FROM articles LEFT JOIN likes ON likes.user_id = X AND likes.article_id = articles.id WHERE articles.author_id = Y

but I get nonsense, which has nothing to do with what I need.

Answer 1

The answer was given on stackoverflow.
Decision:

SELECT 
  a.id, a.title, 
  (SELECT 
     count(*) 
   FROM likes l 
   WHERE l.user_id = <пользователь_X>
   and   l.article_id = a.id) liked_cnt 
FROM articles a
WHERE a.author_id = <определнный_автор>

Answer 2

SELECT `a`.*, `l`.`article_id` IS NOT NULL
  FROM `articles` AS `a`
  LEFT JOIN `likes` AS `l`
    ON `l`.`article_id` = `a`.`id` AND `l`.`user_id` = :userId
  WHERE `a`.`author_id` = :authorId