Question that have been closed and reopened multiple times

0

Please login or register to vote for this query.

(click on this box to dismiss)

German Language Meta

Q&A about the site for speakers of German wanting to discuss the finer points of the language and translation

SELECT TOP 20 * FROM
(
  SELECT PostId, Text
  FROM PostHistory as ph
  WHERE ph.PostHistoryTypeId = 10
  AND ph.Comment LIKE 101
) AS d
JOIN PostLinks as pl on d.PostId = pl.RelatedPostId
WHERE pl.LinkTypeId = 3
--AND d.Text LIKE pl.PostId
--ORDER BY CloseReopenCount DESC, t.PostId
;

Enter Parameters

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