inverted duplicate

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 pl.PostId as [Post Link], pl.RelatedPostId as [Post Link], pl.CreationDate
FROM
(
  SELECT PostId, Text
  FROM PostHistory as ph
  WHERE ph.PostHistoryTypeId = 10
  AND ph.Comment LIKE 101 OR ph.Comment LIKE 1
) AS d
JOIN PostLinks as pl on d.PostId = pl.RelatedPostId
WHERE pl.LinkTypeId = 3
AND d.Text LIKE CONCAT('%', pl.PostId, '%')
AND pl.CreationDate > '2019-01-01 00:00:00'
--ORDER BY CloseReopenCount DESC, t.PostId
ORDER BY pl.CreationDate DESC
;

Enter Parameters

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