1

Please login or register to vote for this query.

(click on this box to dismiss)

Up & Down votes for specified user(s) on Questions and Answers, in order of vote time

Q&A for people interested in the history and origins of science and mathematics

select
  format(v.creationdate,'yyyy-MM-dd') as [Date Voted],
  case when votetypeid=2 then 'Up' else 'Down' end as [Vote],
  p.id as [Post Link],
  case when posttypeid=1 then 'Q' else 'A' end as [Type],
  format(p.creationdate,'yyyy-MM-dd') as [Date Answered]
from votes v left join posts p on p.id=v.postid 
where p.owneruserid in (##UserID##)
  and posttypeid in (1,2)
  and votetypeid in (2,3)
order by v.id

--UserID:Enter one (or more, comma separated) numeric User ID's:

fork query

edited nov 3 18

created nov 3 18 ashleedawg