1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientists using computers to solve scientific problems

SELECT p.Id As [Post Link], 
  p.CreationDate, p.Score, 
CASE p.PostTypeId
    WHEN 1 THEN 'Question'
    WHEN 2 THEN 'Answer'
  END,
  q.Tags, q.ViewCount, q.Title
FROM Posts q INNER JOIN PostTags pt ON q.Id=pt.PostId
INNER JOIN Tags t ON t.id = pt.TagId
INNER JOIN Posts p ON coalesce(p.ParentId, p.Id)=q.Id 
WHERE (p.OwnerDisplayName='user' + Convert(nvarchar(20), ##UserId##))
  AND (q.PostTypeId=1) AND (t.TagName=##tagName:string?set-theory##)

fork query

edited jun 8

created jun 8 Martin20528