Questions with the tag raw as of 2012/12/11

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for programmers

select distinct 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'

edited dec 11