Tag-info edits by a given user

1

Please login or register to vote for this query.

(click on this box to dismiss)

The Workplace Meta

Q&A about the site for members of the workforce navigating the professional setting

SELECT concat(
          'site://tags/',
          t.tagname,
          '/info|', 
          t.tagname, 
          ' ',  
          case when p.posttypeid = 4 then 'excerpt' else 'wiki' end
          ) [Tag Link]
     , p.body, h.comment
FROM PostHistory h 
JOIN Posts p ON h.PostId=p.Id
inner join tags t on (t.wikipostid = p.id or t.excerptpostid = p.id)
WHERE (p.PostTypeId in (4,5)) 
AND (h.PostHistoryTypeId in (2,5)) 
AND (h.UserId=##UserId##)

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results