1

Please login or register to vote for this query.

(click on this box to dismiss)

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 like '%go%'
    or tags like '%aspnet%'
    or tags like '%python%'
    --or tags like '%javascript%'
    or tags like '%dotnetcore%') 
    and CreationDate>'2018-01-01'
ORDER BY 
    Score DESC,ViewCount desc,creationdate desc

view current version

edited dec 27 19

created mar 8 19 Hamed.Aali