SELECT p1.Id id1, p1.Title title1, p1.ViewCount, p1.Score...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Interpersonal Skills

Q&A for people looking to improve their interpersonal communication skills

SELECT 
  p1.Id id1,
  p1.Title title1,
  p1.ViewCount,
  p1.Score,
  PostLinks.LinkTypeId,
  p2.Id id2,
  p2.Title title2
FROM PostLinks
INNER JOIN Posts p1 ON PostLinks.PostId = p1.Id
INNER JOIN Posts p2 ON PostLinks.RelatedPostId = p2.Id
WHERE p2.Id IN (5767325, 503093, 1789945)
  AND p1.Title COLLATE Latin1_General_CI_AS like 'how %'
  AND PostLinks.LinkTypeId = 3 /* 1:Linked, 3:Duplicate*/

Enter Parameters

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