StackExchangeUser.where(:id => Post.joins(:posts_reasons).where(:posts_reasons => { :reason_id => Reason.all.map { |r| [r.id, r.reason_name] }.map { |x| x[1].downcase.include?("repeat") ? x[0] : nil }.compact }).map(&:id)).where.not(:reputation => nil).group(:reputation).count.select { |k, v| k < 100 }.map { |k, v| v }.sum

Post.all.joins('inner join posts as p2 on posts.id = (p2.id - 1)').where('posts.id < ?', Post.all.count).joins(:reasons).group('reasons.reason_name').average('timestampdiff(second, posts.created_at, p2.created_at)').sort_by { |k, v| v }.to_h

2017-03-10 07:03:42.598958 UTC
  File "/home/ubuntu/ws/SmokeDetector/excepthook.py", line 48, in run_with_except_hook
    run_old(*args, **kw)

  File "/usr/lib/python2.7/threading.py", line 754, in run
    self.__target(*self.__args, **self.__kwargs)

  File "/home/ubuntu/ws/SmokeDetector/ChatExchange/chatexchange/browser.py", line 714, in _runner
    self.on_activity(json.loads(a))

  File "/home/ubuntu/ws/SmokeDetector/ChatExchange/chatexchange/rooms.py", line 85, in on_activity
    event_callback(event, self._client)

Uncaught TypeError: Error processing argument at index 0, conversion failure from undefined
  at HTMLAnchorElement.$.on.event (<...>/coal/ui/index.js:19:17)