Nonclosed questions with only one broad tag


Please login or register to vote for this query.

(click on this box to dismiss)


Q&A for scientists, academics, teachers, and students in the field of chemistry

Declare @Tags nvarchar(30)
Set @Tags='<##Tag##>'
Set @Tags = Lower(@Tags)
SELECT p.Id AS [Post Link], p.Score, p.ViewCount, p.OwnerUserId as [User Link], p.CreationDate
FROM Posts p
WHERE PostTypeId = 1
AND Tags = @Tags
AND ClosedDate is null
order by Score desc

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results