SELECT TOP 1000 p.Id AS [Post Link], u.Id AS [User Link]...

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

-- Enter Query Title
-- Enter Query Description

SELECT TOP 1000 
   p.Id AS [Post Link], 
   u.Id AS [User Link], 
   p.ViewCount,
   p.Tags,  
   Year(p.LastActivityDate), 
   Month(p.LastActivityDate), 
   CASE WHEN p.ClosedDate IS NULL THEN 'No' ELSE 'Yes' END AS Closed
FROM Posts p
INNER JOIN Users U on P.OwnerUserId = U.Id
WHERE p.PostTypeId = 1 
   AND p.AnswerCount <= 3
ORDER BY Year(p.LastActivityDate), Month(p.LastActivityDate), p.Score, p.ViewCount

Enter Parameters

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