Q&A for committed Christians, experts in Christianity and those interested in learning more
SELECT TOP 15
Id AS [Post URL],
ViewCount as Views,
ClosedDate as 'Date Closed'
-- PostTypeId of 1 is a question
PostTypeId = 1 AND
-- We want unanswered questions, right?
AnswerCount = 0 AND
-- Let's go for some tumbleweeds too (less likely to be closed)
ViewCount < 500 AND
-- make Id be more than a certain amount,
-- in this case a random point in the posts list
-- Note that because we order by 'Id',
-- the posts returned will all be sequential.
Id > RAND() *
(SELECT TOP 1
ORDER BY Id DESC)
ORDER BY Id