Spam/offensive flags on CGCC Meta

0

Please login or register to vote for this query.

(click on this box to dismiss)

Code Golf and Coding Challenges Meta

Q&A about the site for programming puzzle enthusiasts and code golfers

-- On 2015-10-03, the reputation requirement to post on CGCC Meta was reduced to 1
-- https://codegolf.meta.stackexchange.com/revisions/7084/4
-- https://codegolf.meta.stackexchange.com/q/12852/66833 asks if
-- meta got any spam after this change was made

-- Uncomment line 18 to see all spam/offensive flags after 2015-10-03

select
  case
    when VoteTypeId =  4 then 'Offensive Flag'
    when VoteTypeId = 12 then 'Spam Flag'
  end as [Flag Type],
  CreationDate as Date
from
  Votes
where
  VoteTypeId in (4, 12)
  and CreationDate > '2015-10-03'
order by
  CreationDate
   desc

Enter Parameters

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