Question that have been closed and reopened multiple times


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

  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, '%')
--ORDER BY CloseReopenCount DESC, t.PostId
ORDER BY pl.CreationDate DESC

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results