0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for members of the workforce navigating the professional setting

select *
from posts a
         left join posttags b on a.id = b.postid
         left join tags c on b.tagid = c.id
where year(a.creationdate) = 2017
order by c.count desc;

fork query

edited oct 9 19

created oct 9 19 anonymous