inverted duplicate

1

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Different

Q&A for power users of Apple hardware and software

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 meta site
loading Hold tight while we fetch your results