Questions with a specific tag and the tag raw

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.Title
  from Posts p
  left join PostTags pt on p.Id = pt.PostId
  left join Tags t on pt.TagId = t.Id
  left join PostTags pt2 on p.Id = pt2.PostId
  left join Tags t2 on pt2.TagId = t2.Id
 where postTypeId = 1
   and t.tagName = 'raw'
   and t2.tagName = ##tag:string##
 order by ViewCount desc;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached