0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for expert genealogists and people interested in genealogy or family history

-- Query to find top users related to Microsoft 365 CRM topics
-- Adjust the tags as necessary for more specific topics
SELECT TOP 50
    u.Id AS [User Link],
    u.DisplayName,
    u.Reputation,
    COUNT(p.Id) AS [Post Count],
    MAX(p.CreationDate) AS [Last Post Date]
FROM Posts p
INNER JOIN PostTags pt ON p.Id = pt.PostId
INNER JOIN Tags t ON pt.TagId = t.Id
INNER JOIN Users u ON p.OwnerUserId = u.Id
WHERE t.TagName IN ('microsoft-dynamics', 'crm', 'microsoft-dynamics-crm', 'office365', 'powerapps', 'power-automate', 'dynamics-365')
GROUP BY u.Id, u.DisplayName, u.Reputation
ORDER BY u.Reputation DESC

fork query

created jul 1 anonymous