Q&A for power users of web applications
SELECT TOP ##number## q.Id, url = 'site://q/' + CAST(q.Id AS varchar), COUNT(*) AS NumAnswers, q.Tags FROM PostsWithDeleted q INNER JOIN PostsWithDeleted a ON a.ParentId = q.Id WHERE (q.Tags LIKE '%##Tagname##%') and (q.Deletiondate IS NOT NULL) and (q.PostTypeId =1) and (a.PostTypeId=2) GROUP BY q.Id, q.Tags ORDER BY NumAnswers DESC