Recent tag-info edits

1

Please login or register to vote for this query.

(click on this box to dismiss)

Physical Fitness Meta

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

SELECT TOP(##num?250##)
     concat(
          'site://tags/',
          t.tagname,
          '/info|',
          t.tagname,
          ' ',
          case when p.posttypeid = 4 then 'excerpt' else 'wiki' end
          ) [Tag Link]
     , h.UserId AS [User Link], p.body, h.comment, h.CreationDate
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))
ORDER BY h.Id DESC

Enter Parameters

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