Most frequently linked questions with the given word and the given tag

1

Please login or register to vote for this query.

(click on this box to dismiss)

Computational Science

Q&A for scientists using computers to solve scientific problems

;with counts_cte AS (SELECT
  RelatedPostId AS id,
  COUNT(PostId) AS count
FROM PostLinks
WHERE (LinkTypeId IN (##linktypes?1,3##))
GROUP BY RelatedPostId
---LinkTypeId type of link
---1 = Linked (PostId contains a link to RelatedPostId)
---3 = Duplicate (PostId is a duplicate of RelatedPostId)
)

SELECT TOP(##num?500##)
  p.Id AS [Post Link],
  c.count,
  linked = 'site://questions/linked/' + CAST(p.Id AS varchar),
  p.Title,
  p.Score,
  p.ViewCount,
  p.AnswerCount,
  p.Tags
FROM counts_cte c INNER JOIN Posts p ON p.id=c.id
INNER JOIN PostTags pt ON p.Id=pt.PostId
INNER JOIN Tags t ON t.id = pt.TagId
WHERE (t.TagName=##tagName:string?set-theory##) 
  AND (p.Body LIKE '%##Word?ultrafilter##%' COLLATE Latin1_General_CI_AI)
ORDER BY c.count DESC

Enter Parameters

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