Q&A for enthusiasts and power users of the Android operating system
DECLARE @tag_ids int = (SELECT id FROM tags WHERE tagname IN (##Tags:string##)); SELECT users.id, users.DisplayName, users.AboutMe, users.id "User Link", COUNT(answers.id) AS "NumAnswers" FROM users JOIN posts answers ON (users.id = answers.owneruserid) JOIN posts parent ON (answers.parentid = parent.id) JOIN posttags ON (parent.id = posttags.postid) WHERE parent.CreationDate < '2019-06-24' -- For CAST only, uncomment the next 2 lines: -- AND -- parent.id IN (26496292, 55459855) AND answers.CreationDate < '2019-06-24' AND posttags.tagid IN (@tag_ids) AND ( LOWER(parent.Body) LIKE LOWER('%Technical Debt%') OR LOWER(parent.Title) LIKE LOWER('%Technical Debt%') ) GROUP BY users.id, users.DisplayName, users.AboutMe ORDER BY NumAnswers DESC ;