SELECT a.CreationDate, a.Id AS [Post Link], CHARINDEX(h.T...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Gardening and Landscaping Meta

Q&A about the site for gardeners and landscapers

SELECT a.CreationDate, a.Id AS [Post Link], CHARINDEX(h.Text, CAST(##UserId:int## AS NVARCHAR))
  FROM Posts AS a
  INNER JOIN Posts AS q
    ON a.ParentId = q.Id
  INNER JOIN PostHistory AS h
    ON h.PostId = q.Id
   AND h.PostHistoryTypeId = 10 -- Post closed
   AND h.Comment = 101 -- Duplicate
  WHERE a.OwnerUserId = ##UserId:int##

Enter Parameters

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