Two mysql select queries into one query user

id   |  name
1    |  A
2    |  B


article

id   | title | descritption
1    | wx    | xyz
2    | yz    | abc


article_rating

article_id(article-&gt;id)  |  given_by(user-&gt;id)  |  given_rating
   1                              2                  4
   2                              1                  3


saved_article

article_id(article-&gt;id)  |  saved_by(user-&gt;id) 
   1                              2            


I'm changing some buttons and icons depending on whether a user has rated/ saved an article or not. I'm using two select queries for that:

rated or not

SELECT given_rating as rating 
FROM article_rating 
WHERE  given_by=? AND article_id=?


saved or not

SELECT saved_by as saved 
FROM saved_article 
WHERE  saved_by=? AND article_id=?


So my question is how can i combine both into one mysql query efficiently??
If the article_id is the same in both tables, and you are looking for the same article in both tables, then you could use an INNER JOIN to join the two tables, using the article_id column.

SELECT ar.given_rating as rating, sa.saved_by as saved 
FROM article_rating  ar
INNER JOIN saved_article sa
ON ar.article_id = sa.article_id
WHERE ar.given_by=? AND sa.saved_by=? AND ar.article_id=?;


DB-Fiddle