Vote trends on my posts

0

Please login or register to vote for this query.

(click on this box to dismiss)

Audio-Video Production Meta

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

select round(year(p.CreationDate), 0) year, 
       Name,
       1.0*count(distinct v.Id)/count(distinct p.Id) "votes per post"
       
from Votes v
     join Posts p on PostId = p.Id
     join VoteTypes vt on vt.Id = VoteTypeId
where OwnerUserId = ##user?1438##
      and Name like '%Mod'
      --and Name = 'DownMod'
group by year(p.CreationDate), Name
order by year(p.CreationDate), Name

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results