0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

SELECT
    Posts.Id,
    Posts.CreationDate,
    Posts.DeletionDate,
    Posts.Title as OriginalQuestionTitle,
    A.Title as DuplicateQuestionTitle,
    Posts.Body as OriginalQuestionBody,
    A.Body as DuplicateQuestionBody,
    Posts.Tags,
    Posts.Score,
    Posts.ViewCount,
    Posts.AnswerCount,
    Posts.CommentCount,
    Posts.FavoriteCount,
    Posts.ClosedDate
    --CountDup
  
FROM (
  SELECT Posts.Title, Posts.Id AS Id, Posts.Body AS Body,
    PostLinks.LinkTypeId AS LinkType, PostLinks.RelatedPostId AS DuplicateId
   FROM Posts 
     JOIN PostLinks ON Posts.Id = PostLinks.PostId
       AND PostLinks.LinkTypeId = 3 
       AND Posts.Score > 0 

  ) A JOIN Posts ON Posts.Id = A.DuplicateId
  WHERE Posts.CreationDate > '2008-01-01'
    AND(Posts.CreationDate < '2010-01-01')
  ORDER BY Posts.CreationDate ASC

fork query

edited jun 9 21 anonymous

created oct 30 17 MBartolo