finds open questions with score <= -5
Q&A for those using, extending or developing Emacs
DECLARE @tag VARCHAR(30) = ##TagToSearchIn:string## SELECT TOP 1000 Id AS [Post Link], Score, ViewCount as Views, AnswerCount as Answers, Body FROM Posts WHERE AcceptedAnswerId IS NULL AND PostTypeId = 1 AND ClosedDate IS NULL AND Score <= -5 AND Tags LIKE '%<' + LOWER(@tag) + '>%'