/*select count(*) from (*/ SELECT p1.Id, p1.Title title1...

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 count(*) from (*/

SELECT 
  p1.Id,
  p1.Title title1,
  p1.ViewCount,
  p1.Score,
  PostLinks.LinkTypeId,
  p2.Id,
  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 = 5767325
  AND p1.Title COLLATE Latin1_General_CI_AS like 'how %'
  AND PostLinks.LinkTypeId = 3 /* 1:Linked, 3:Duplicate*/
/*) as T*/

Enter Parameters

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