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

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 id1,
  p1.Title title1,
  p1.ViewCount,
  p1.Score,
  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 PostLinks.LinkTypeId = 3 /* 1:Linked, 3:Duplicate*/
AND (p1.PostTypeId=1
  and p1.Tags like '%<javascript>%'
  and (p1.Title COLLATE Latin1_General_CI_AS like 'how to %'
    or p1.Title COLLATE Latin1_General_CI_AS like 'how do %'
    or p1.Title COLLATE Latin1_General_CI_AS like 'how may %'
    or p1.Title COLLATE Latin1_General_CI_AS like 'how might %'
    or p1.Title COLLATE Latin1_General_CI_AS like 'how can %'
    or p1.Title COLLATE Latin1_General_CI_AS like 'how could %'
    or p1.Title COLLATE Latin1_General_CI_AS like 'how should %'
  )
)
AND (p2.PostTypeId=1
  and p2.AnswerCount > 0
  and p2.Tags like '%<javascript>%'
  and (p2.Title COLLATE Latin1_General_CI_AS like 'how to %'
    or p2.Title COLLATE Latin1_General_CI_AS like 'how do %'
    or p2.Title COLLATE Latin1_General_CI_AS like 'how may %'
    or p2.Title COLLATE Latin1_General_CI_AS like 'how might %'
    or p2.Title COLLATE Latin1_General_CI_AS like 'how can %'
    or p2.Title COLLATE Latin1_General_CI_AS like 'how could %'
    or p2.Title COLLATE Latin1_General_CI_AS like 'how should %'
  )
)
ORDER BY p2.ViewCount DESC, p1.ViewCount DESC
/*) as T*/

Enter Parameters

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