Find suspicious answers to flag

0

Please login or register to vote for this query.

(click on this box to dismiss)

Russian Language

Q&A for students, teachers, and linguists wanting to discuss the finer points of the Russian language

-- I just want to earn Marshal badge

DECLARE @LastWeek DateTime = dateadd(day, datediff(day, 8, GETDATE()), 0)

-- Answers that are complained by the bot
SELECT TOP 500
  p.Id [Post Link],
  p.Body
FROM Posts p
JOIN Comments c ON p.Id = c.PostId
WHERE p.PostTypeId = 2
  AND p.DeletionDate IS NULL
  AND c.UserId = -1
  AND c.Text LIKE '%your answer is unclear%'
ORDER BY c.CreationDate DESC

-- Answers that are suspiciously short
SELECT TOP 100
  Id AS [Post Link],
  Body,
  LEN(Body) Length
FROM Posts
WHERE CreationDate >= @LastWeek
  AND PostTypeId = 2
  AND LEN(Body) <= 120
ORDER BY Length ASC

Enter Parameters

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