Posts Closed for off-topic

0

Please login or register to vote for this query.

(click on this box to dismiss)

Music Fans Meta

Q&A for music historians, critics, and fans

select
  p.Title,
  p.Body,
  p.Id as [Post Link],
  pl.RelatedPostId as [Post Link],
  linked_p.Title,
  linked_p.Body
from
  Posts p
  left join PostHistory ph on (p.Id = ph.PostId) and ph.PostHistoryTypeId = 10
  left join CloseReasonTypes crt on crt.Id = ph.Comment
  left join PostLinks pl on p.Id = pl.PostId
  left join Posts linked_p on pl.RelatedPostId = linked_p.Id
where
  --p.ClosedDate is not null and
  p.ClosedDate > '2018-05-18'
  --and crt.Id = 101
  and pl.LinkTypeId = 3
  --and pl.RelatedPostId is not null

Enter Parameters

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