-10

I am curious that out of all the sites which question has the most votes. I do not know if there is any easy way to do this (and I am to lazy to do it the hard way) so can you please help me? Thank you

4

You can always use The Stack Exchange Data Explorer to feed most of your curiosity.

I've created the following so called networkwide query. That script basically runs this query for each site:

select 
       postid as [Post Link]
     , sum(case when votetypeid = 2 then 1 else 0 end) [upvotes]
     , sum(case when votetypeid = 3 then 1 else 0 end) [downvotes]
     , count(*) [total]
from votes v
inner join posts p on p.id = v.postid
where votetypeid in (2,3) -- up , down
and p.posttypeid = 1 -- Q 
group by postid
having count(*) > 200
order by count(*) desc

When you run the network wide script today you'll get this list:

sede results

It confirms the post Rand al'Thor already found is the highest voted question.

Filtering out Stack Overflow gives a somewhat more interesting results:

sede results without stack overflow

Keep in mind SEDE is updated once a week on Sunday.
Give a big shout-out to Monica Cellio for the awesome SEDE Tutorial she wrote.
Say "Hi" in SEDE chat.

| improve this answer | |
2

Since Stack Overflow almost always has the biggest stats of any site on the network, I'm going to go with this one:

Why is processing a sorted array faster than processing an unsorted array? (score 24094 at time of writing).

| improve this answer | |

Not the answer you're looking for? Browse other questions tagged .