select top 10 * from Votes v join Posts p on p.Id = v.Pos...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Space Exploration

Q&A for spacecraft operators, scientists, engineers, and enthusiasts

select top 10 * 
from Votes v
join Posts p on p.Id = v.PostId
join PostTypes pt on pt.Id = p.PostTypeId
join VoteTypes vt on vt.Id = v.VoteTypeId
where p.PostTypeId = 1 --question
  and p.OwnerUserId = 2639 -- EVUN
  and v.CreationDate <= dateadd(day,1,p.CreationDate)
  -- and vt.Id = 3 -- DownMod

Enter Parameters

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