Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Japanese language
;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 (p.Body LIKE '%##word1?idempotent##%' COLLATE Latin1_General_CI_AI) AND (p.Body LIKE '%##word2?ultrafilter##%' COLLATE Latin1_General_CI_AI) ORDER BY c.count DESC