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)

The Workplace Meta

Q&A about the site for members of the workforce navigating the professional setting

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 '2012' and '2013'
order by rand(50)

Enter Parameters

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