Tag wikis created by a deleted user

0

Please login or register to vote for this query.

(click on this box to dismiss)

MathOverflow

Q&A for professional mathematicians

Select concat(
          'site://tags/',
          t.tagname,
          '/info|', 
          t.tagname, 
          ' ',  
          case when p.posttypeid = 4 then 'excerpt' else 'wiki' end
          ) [Tag Link]
     , p.Body
From Posts p
inner join tags t on (t.wikipostid = p.id or t.excerptpostid = p.id)
Where (OwnerDisplayName='user' + Convert(nvarchar(20), ##UserId##)) AND
  ((PostTypeId = 3) OR (PostTypeId=4))

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results