select top 10000 p1.Id, p1.CreationDate, p1.AcceptedAnswe...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Christianity

Q&A for committed Christians, experts in Christianity and those interested in learning more

select top 10000
  p1.Id, 
  p1.CreationDate,
  p1.AcceptedAnswerId,
  p1.OwnerUserId,
  p1.AnswerCount,
  p1.LastEditDate
from Posts p1
where
  p1.PostTypeId = 1
  and p1.AcceptedAnswerId >=1
  and p1.OwnerUserId is not null
  and p1.CreationDate between '2011' and '2012'
order by rand(50)

Enter Parameters

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