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 WHERE (p.Body LIKE '%##Word1?invariant##%' COLLATE Latin1_General_CI_AI) AND (p.Body LIKE '%##Word2?subspace##%' COLLATE Latin1_General_CI_AI) ORDER BY c.count DESC