1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for finance professionals and academics

;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

fork query

created oct 27 Martin20528