6

Is there any way I can check all Stack Exchange communities to find the worst (or best) voted question (as of now). I found one with -10 votes, and I forgot where that was. For curiousity, how many votes will it take to ban (or promote) a user?

3
  • The algorithm for banning is kept secret, to prevent people from gaming it. – S.L. Barth Jul 11 '16 at 6:32
  • You mean your own posts, or any posts? – Shadow The Vaccinated Wizard Jul 11 '16 at 6:36
  • Which are the worst voted questions and or posts? Is there some way of keeping track? – J. Linne Jul 11 '16 at 6:38
10

If you want to know the most downvoted or the worst scoring post, SEDE is the way to go.

For example, for Stack Overflow:

For MSE:

You can run this query for the site you want, or with some extra work run it for all sites in the network at once.

Note that this queries will only return the posts that are not deleted. Deleted post can't be queries using SEDE.

SE does not release any information on the script determining when someone gets banned or not. That is kept confidential to prevent misuse of the algorithm.

3
  • 1
    Worth to mention the -270 scored question got 440 downvotes, maybe worth running the queries to get most voted posts with only up/down votes, not net score. – Shadow The Vaccinated Wizard Jul 11 '16 at 7:13
  • Indeed. Updated @Sha – Patrick Hofman Jul 11 '16 at 7:17
  • The worse non-deleted downvoted answer on MSE was posted by Jeff Atwood himself. Hmm. – John Militer Jul 15 '16 at 0:50
3

The worst question seems to be this one with a score of -270. The best question is the well-known branch prediction question.

I found them using this SEDE query - keep in mind that the data is refreshed once a week on Sunday morning.

-- all databases
declare  db_c cursor for select [name] 
                         from sys.databases 
                         where database_id > 5 -- skip master, temp, model, msdb, Data.SE

declare @db_c_name sysname   -- holds name of db after fetch
declare @sql nvarchar(max) -- holds build up sql string

-- result table
create table #worstquestions (site nvarchar(250), id int, score int, title nvarchar(250));
create table #bestquestions (site nvarchar(250), id int, score int, title nvarchar(250));


open db_c
fetch next from db_c into @db_c_name
while(@@FETCH_STATUS = 0)
begin
    set @sql = N'use '+ QUOTENAME(@db_c_name) + ';
    insert into #worstquestions 
    select top 1 ''' + QUOTENAME(@db_c_name) + ''', id, score, title
      from posts
      where posttypeid = 1
      order by score asc;
    insert into #bestquestions 
    select top 1 ''' + QUOTENAME(@db_c_name) + ''', id, score, title
      from posts
      where posttypeid = 1
      order by score desc';

    exec (@sql)
   fetch next from db_c into @db_c_name
end;
close db_c;
deallocate db_c;

select * from #worstquestions order by score asc;
select * from #bestquestions order by score desc;

For curiousity, how many votes will it take to ban (or promote) a user?

For banning, this will not be disclosed to mere users, like you and me. There's too much potential for abuse. I don't understand what you mean by promotion.

You must log in to answer this question.

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