Q&A about the site for science fiction and fantasy enthusiasts
--DECLARE @UserId int = ##UserId## SELECT top 1000 p.tags,p.id as [Post Link],Title,AnswerCount, p.Score FROM Posts p join postTags pt on p.id=pt.postId join TagSynonyms t on t.id=pt.TagId WHERE -- (AcceptedAnswerId is null) and answercount<10 and ClosedDate is null and TargetTagName in ( '.net' , '.net-4.0' , '.net-core' --, 'api' , 'asp.net-core' , 'asp.net-core-2.0' , 'asp.net-core-2.2' , 'asp.net-core-3.0' , 'asp.net-core-3.1' , 'asp.net-core-mvc' , 'asp.net-identity' , 'asp.net-mvc ' , 'asp.net-mvc-2' , 'asp.net-mvc-3' , 'asp.net-mvc-4' , 'asp.net-mvc-5' , 'asp.net-web-api' , 'asp.net-web-api2' , 'async-await ' , 'c#' , 'c#-4.0 ' --, 'cmd' , 'database' , 'database-design' , 'datagridview' --, 'datatable' --, 'datatables' , 'datetime' , 'debugging' , 'dependency-injection' , 'design-patterns' --, 'dictionary' , 'dll' , 'ef-code-first' , 'ef-core-2.0' , 'ef-core-2.1' , 'ef-core-2.2' , 'ef-core-3.0' , 'ef-core-3.1' , 'entity-framework' , 'entity-framework-4' , 'entity-framework-core' , 'foreach' --, 'function' , 'github' , 'go' , 'group-by' , 'tfs' , 'iis' , 'iis-7' , 'iis-10' , 'commit' , 'join' , 'git' ) and p.CreationDate>'2015-01-01' and p.Score>5 ORDER BY p.Score DESC,p.creationdate desc,p.ViewCount desc