0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site 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 like '%go%'
     or tags like '%aspnet%'
     or tags like '%mvc%'
     or tags like '%html%'
     or tags like '%dotnetcore%') 
    --and CreationDate>'2018-01-01'
ORDER BY 
    Score DESC,ViewCount desc,creationdate desc

fork query

edited jul 19

created mar 8 Hamed.Aali