0

Please login or register to vote for this query.

(click on this box to dismiss)

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)

view current version

edited nov 14

created nov 14 jon.doe32599