Top 10 Posts with most Upvotes per year


Please login or register to vote for this query.

(click on this box to dismiss)

Spanish Language

Q&A for linguists, teachers, students and Spanish language enthusiasts in general wanting to discuss the finer points of the language

    , year(p.creationdate) as creationdateyear
    , case when u.upvotes is null then 0 else u.upvotes end as upvotes
  from posts p
  left join(
    select postid, count(votetypeid) as upvotes
    from postfeedback
    where votetypeid = 2
    group by postid
  ) u on u.postid =
  where = 231855

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results