top questions without accepted answer

1

Please login or register to vote for this query.

(click on this box to dismiss)

Craft CMS

Q&A for administrators, end users, developers and designers for Craft CMS

--DECLARE @UserId int = ##UserId##

SELECT top 1000
    id  as [Post Link],Title,AnswerCount,
    Score
FROM 
    Posts
WHERE 
     (AcceptedAnswerId is null) and
     answercount<10
    and ClosedDate is null
   --and (tags like '%c#%' 
   --or tags like '%sql-server%'
    --or tags = 'go'
    --or tags like '%aspnet%'
    --or tags like '%python%'
    --or tags like '%javascript%'
    --or tags like '%dotnetcore%') 
    and CreationDate>'2019-01-01'
    and Score>5
ORDER BY 
    creationdate desc,Score DESC,ViewCount desc

Enter Parameters

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