Questions with a specific tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

select p.Id as [Post Link], p.Score, p.ViewCount, p.OwnerUserId as [User Link], p.CreationDate, p.LastEditDate
from Posts p
left join PostTags pt on p.Id = pt.PostId
left join Tags t on pt.TagId = t.Id
where  postTypeId = 1
and tagName = ##tag:string##
order by ViewCount desc;
fork query

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
Results Messages Graph Execution Plan
Download CSV Download XML
:records rows returned in :time ms:cached