Seek and Destroy: Comments with the phrase "not an answer"

0

Please login or register to vote for this query.

(click on this box to dismiss)

A query to help look for non-answers--comments with the phrase "not an answer" on answers with low score. Flags ahoy! But try not to *completely* overwhelm the poor moderators, 'k?

Emacs

Q&A for those using, extending or developing Emacs

select a.id as [Post Link], 
  a.score as [Answer Score], 
  c.text as [Comment Text],
  a.body as [Answer Text],
  a.CreationDate
from comments c
  inner join posts a on c.postid = a.id
-- where a.posttypeid = 2               -- answers
  and a.score < 2                    -- with low score
  
  and (
  --c.text like 'This does not provide an answer to the question. Once you have sufficient reputation you will be able to comment on any post; instead, provide answers that don\'t require clarification from the asker.%'
  --or c.text like 'Please don\'t add "thank you" as an answer. Instead, vote up the answers that you find helpful.%'
  --or c.text like 'This does not really answer the question. If you have a different question, you can ask it by clicking Ask Question. You can also add a bounty to draw more attention to this question once you have enough reputation.%'
  --c.text like 'If you have a new question, please ask it by clicking the Ask Question button. Include a link to this question if it helps provide context.%'
  c.text like 'While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes.%'
)
and c.CreationDate > '2020-05-02 19:44:34'

order by a.score

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results