Nonclosed questions with only one broad tag

2

Please login or register to vote for this query.

(click on this box to dismiss)

Chemistry

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

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