0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for pro webmasters

SELECT COUNT(Posts.Id), Posts.Id AS "Id.x", COUNT(Users.UpVotes)
FROM Posts
LEFT JOIN
Users ON (Posts.Id = Users.Id)
GROUP BY Posts.Id
ORDER BY COUNT(Posts.Id) desc

fork query

edited nov 12

created nov 11 anonymous