What effect do post notices have on answer voting?

0

Please login or register to vote for this query.

(click on this box to dismiss)

https://meta.stackexchange.com/questions/278800/what-effect-do-post-notices-have-on-answer-voting

Italian Language Meta

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language

select pn.postid
     , sum(case 
           when v.votetypeid = 2 
            and v.creationdate < pn.creationdate  
           then 1 
           else 0
           end ) [upvotes before notice]
     , sum(case 
           when v.votetypeid = 2 
            and v.creationdate >= pn.creationdate  
           then 1 
           else 0
           end ) [upvotes after notice]
     , sum(case 
           when v.votetypeid = 3
            and v.creationdate < pn.creationdate  
           then 1 
           else 0
           end ) [downvotes before notice]
     , sum(case 
           when v.votetypeid = 3 
            and v.creationdate >= pn.creationdate  
           then 1 
           else 0
           end ) [downvotes after notice]
from postnotices pn
inner join  postnoticetypes pnt on pnt.id = pn.postnoticetypeid
left outer join votes v on v.postid = pn.postid
where postnoticetypeid in (1,3)
and v.votetypeid in (2,3)
group by pn.postid

select *
from postnoticetypes

Enter Parameters

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