Q&A for people interested in improving and participating in the patent system
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) WHERE parent.CreationDate < '2019-06-24' AND answers.CreationDate < '2019-06-24' AND ( LOWER(parent.Title) LIKE LOWER('% ##words## %') OR LOWER(parent.Title) LIKE LOWER('% ##words##') OR LOWER(parent.Title) LIKE LOWER('##words## %') OR LOWER(parent.Title) LIKE LOWER('% ##words##-%') OR LOWER(parent.Title) LIKE LOWER('%-##words## %') ) 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 ;