Downvoted questions by day without other markers

1

Please login or register to vote for this query.

(click on this box to dismiss)

Amateur Radio

Q&A for amateur radio enthusiasts

/*--How many questions that day?
Select Posts.Id, Score, OwnerUserId, Title
From Posts
Where CreationDate Between '2012-06-24' And '2012-06-30'
And PostTypeId = 1
Order By Posts.Id;

--How many got downvotes?
Select Posts.Id, Score, VoteTypeId, Count(VoteTypeId), OwnerUserId, Title From Posts
Inner Join Votes On Posts.Id = Votes.PostId
Where Posts.CreationDate Between '2012-06-24' And '2012-06-30'
And PostTypeId = 1
Group By Posts.Id, Title, OwnerUserId, OwnerDisplayName, Score, VoteTypeId
Having VoteTypeId = 3
Order By Posts.Id, VoteTypeId; */

/*--How many questions that day?
Select 'Questions asked:', Count(Id)
From Posts
Where PostTypeId = 1
And CreationDate Between '2012-06-17' And '2012-06-23' 

--How many got downvotes?
Select 'Questions downvoted:', Count(Distinct PostId)
    From Votes 
    Inner Join Posts On Posts.Id = Votes.PostId
  Where PostTypeId = 1
  And Posts.CreationDate Between '2012-06-17' And '2012-06-23' 
  And VoteTypeId = 3

 --How many with close, delete, spam, offensive, mod review votes?
 Select 'Questionable questions:', Count(Distinct PostId)
 From Votes 
    Inner Join Posts On Posts.Id = Votes.PostId
  Where PostTypeId = 1
  And Posts.CreationDate Between '2012-06-17' And '2012-06-23' 
  And VoteTypeId In (4,6,10,12,15)*/
  
  --How many with down votes but no other negative indicators?
Select 'Downvotes Only: ', Count(Distinct PostId)
    From Votes 
    Inner Join Posts On Posts.Id = Votes.PostId
  Where PostTypeId = 1
  And Posts.CreationDate Between '2012-06-17' And '2012-06-23' 
  And VoteTypeId = 3
  And PostId Not In (
    Select Distinct PostId
   From Votes 
    Inner Join Posts On Posts.Id = Votes.PostId
  Where PostTypeId = 1
  And Posts.CreationDate Between '2012-06-17' And '2012-06-23' 
  And VoteTypeId In (4,6,10,12,15))
  
  --How many with negative indicators but no down votes?
  Select 'Negatives Only: ', Count(Distinct PostId)
    From Votes 
    Inner Join Posts On Posts.Id = Votes.PostId
  Where PostTypeId = 1
  And Posts.CreationDate Between '2012-06-17' And '2012-06-23' 
  And VoteTypeId In (4,6,10,12,15)
  And PostId Not In (
    Select Distinct PostId
   From Votes 
    Inner Join Posts On Posts.Id = Votes.PostId
  Where PostTypeId = 1
  And Posts.CreationDate Between '2012-06-17' And '2012-06-23' 
  And VoteTypeId = 3)
  
  --How many with down votes and negative indicators?
  Select 'Downvotes Plus: ', Count(Distinct PostId)
    From Votes 
    Inner Join Posts On Posts.Id = Votes.PostId
  Where PostTypeId = 1
  And Posts.CreationDate Between '2012-06-17' And '2012-06-23' 
  And VoteTypeId = 3
  And PostId In (
    Select Distinct PostId
   From Votes 
    Inner Join Posts On Posts.Id = Votes.PostId
  Where PostTypeId = 1
  And Posts.CreationDate Between '2012-06-17' And '2012-06-23' 
  And VoteTypeId In (4,6,10,12,15))

Enter Parameters

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