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

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(CAST(##UserId:int## AS NVARCHAR), h.Text)
  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