top questions without accepted answer new tags

1

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla Meta

Q&A about the site for Joomla! administrators, users, developers and designers

--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

Enter Parameters

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