Untitled query #14903

SQL

USE bgwiki_p;
SELECT
  rev_user_text,
  SUM(rev_timestamp < 20161217000000) преди,
  SUM(rev_timestamp BETWEEN 20161217000000 AND 20161218235959) конф,
  SUM(rev_timestamp > 20161219000000) след,
  COUNT(*) общо
  FROM revision 
  WHERE rev_user_text IN ('Сале', 'Лорд Бъмбъри', 'ShockD', 'Tropcho', 'Rumensz', 'Спасимир', 'Ilikeliljon', 'Spiritia', 'Ket', 'Nk', 'StanProg', 'Filipov Ivo', 'Alexander.D.Hristov', 'Litev', 'Алиса Селезньова', 'Iliev', 'Plamski13', 'Raychostanev', 'Rey Keshe', 'dimi_z', 'Мико') 
    AND rev_timestamp > 20160916000000
  GROUP BY rev_user
  ORDER BY COUNT(*) DESC;
SQL

Checking query status...
