1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those who study, teach, research and apply economics and econometrics

;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
WHERE (p.Body LIKE '%##Word?coset##%' COLLATE Latin1_General_CI_AI)
ORDER BY c.count DESC

fork query

created jul 30 Martin20528