Finding Duplicate Questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Android Enthusiasts Meta

Q&A about the site for enthusiasts and power users of the Android operating system

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
    --Votes.VoteTypeId
    --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 > 5
       AND Posts.CommentCount >=1
       AND Posts.AnswerCount > 3
       AND Posts.FavoriteCount > 1
       

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

Enter Parameters

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