Q&A for meta-discussion of the Stack Exchange family of Q&A websites
DECLARE @TagLike NVARCHAR(25) = ##taglike:string## select top 2000 q.Id as [Post Link], q.ViewCount from Posts q INNER JOIN PostTags ON q.Id = PostTags.PostId INNER JOIN Tags ON PostTags.TagId = Tags.id where (select count(*) from Posts a where a.ParentId = q.Id and a.Score > 0) = 0 and CommunityOwnedDate is null and ClosedDate is null and q.ParentId is null and AcceptedAnswerId is null AND Tags.TagName LIKE '%' + @TagLike + '%' ORDER BY q.ViewCount DESC