k
Size: a a a
k
Д
k
A
k
A
k
E
R3
Д
АН
SELECT articles.title, count(likes.content_id) as likes_count, count(dislikes.content_id) as dislikes_count FROM articles
LEFT JOIN likes ON articles.id = likes.content_id
LEFT JOIN dislikes ON articles.id = dislikes.content_id
GROUP BY likes.content_id, dislikes.content_id
АН
I
R3
SELECT articles.title, count(likes.content_id) as likes_count, count(dislikes.content_id) as dislikes_count FROM articles
LEFT JOIN likes ON articles.id = likes.content_id
LEFT JOIN dislikes ON articles.id = dislikes.content_id
GROUP BY likes.content_id, dislikes.content_id
АН
R3
АН
СС