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