0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional robotic engineers, hobbyists, researchers and students

select posts.id, count(*) as total_upmod
from posts 
left join votes on posts.id = votes.postid
left join votetypes on votes.votetypeid = votetypes.id
where votetypes.name = 'UpMod' and year(posts.creationDate) = 2018
group by posts.id
;

fork query

edited aug 13

created aug 13 anonymous