USE cswiki_p;
SELECT afl_filter, af_public_comments,
(SUM(IF(afl_actions... |
5 years ago |
USE cswiki_p;
SELECT afl_filter, af_public_comments,
(SUM(IF(afl_actions... |
5 years ago |
USE cswiki_p;
SELECT afl_filter, af_public_comments,
(SUM(IF(afl_actions... |
5 years ago |
USE cswiki_p;
SELECT afl_filter, af_public_comments,
(SUM(IF(afl_actions... |
5 years ago |
USE cswiki_p;
SELECT afl_filter, (SUM(IF(afl_actions LIKE '%warn%', 1, 0)) -... |
5 years ago |
USE cswiki_p;
SELECT afl_filter, (SUM(IF(afl_actions LIKE '%warn%', 1, 0)) -... |
5 years ago |
USE cswiki_p;
SELECT afl_filter, (SUM(IF(afl_actions LIKE '%warn%', 1, 0)) -... |
5 years ago |
USE cswiki_p;
SELECT afl_filter, (SUM(IF(afl_actions LIKE '%warn%', 1, 0)) -... |
5 years ago |
USE cswiki_p;
SELECT afl_filter, (SUM(IF(afl_actions LIKE '%warn%', 1, 0)) -... |
5 years ago |
USE cswiki_p;
SELECT afl_filter, (SUM(IF(afl_actions LIKE '%warn%', 1, 0)) -... |
5 years ago |
USE cswiki_p;
SELECT afl_filter, (SUM(IF(afl_actions LIKE '%warn%', 1, 0)) -... |
5 years ago |
USE cswiki_p;
SELECT afl_filter, (SUM(IF(afl_actions LIKE '%warn%', 1, 0)) -... |
5 years ago |
USE cswiki_p;
SELECT afl_filter, 1 - (SUM(IF(afl_actions LIKE '%warn%', 1,... |
5 years ago |
USE cswiki_p;
SELECT afl_filter, 1 - (SUM(IF(afl_actions LIKE '%warn%', 1,... |
5 years ago |
USE cswiki_p;
SELECT afl_filter, 1 - (SUM(IF(afl_actions LIKE '%warn%', 1,... |
5 years ago |
USE cswiki_p;
SELECT afl_filter, (SUM(IF(afl_actions LIKE '%warn%', 1, 0)) -... |
5 years ago |
USE cswiki_p;
SELECT afl_filter, (SUM(IF(afl_actions LIKE '%warn%', 1, 0)) -... |
5 years ago |
USE cswiki_p;
SELECT afl_filter, (SUM(IF(afl_actions LIKE '%warn%', 1, 0)) -... |
5 years ago |
USE cswiki_p;
SELECT afl_filter, (SUM(IF(afl_actions LIKE '%warn%', 1, 0)) -... |
5 years ago |
USE cswiki_p;
SELECT afl_filter, (SUM(IF(afl_actions LIKE '%warn%', 1, 0)) -... |
5 years ago |
USE cswiki_p;
SELECT afl_filter, (SUM(IF(afl_actions LIKE '%warn%', 1, 0)) -... |
5 years ago |
USE cswiki_p;
SELECT afl_filter, (SUM(IF(afl_actions LIKE '%warn%', 1, 0)) -... |
5 years ago |
USE cswiki_p;
SELECT afl_filter, MAX((SUM(IF(afl_actions LIKE '%warn%', 1,... |
5 years ago |
USE cswiki_p;
SELECT afl_filter, (SUM(IF(afl_actions LIKE '%warn%', 1, 0)) -... |
5 years ago |
USE cswiki_p;
SELECT afl_filter, SUM(IF(afl_actions LIKE '%warn%', 1, 0)),... |
5 years ago |
USE cswiki_p;
SELECT afl_filter, SUM(IF(afl_actions LIKE '%warn%', 1, 0)) -... |
5 years ago |
USE cswiki_p;
SELECT afl_filter, SUM(IF(afl_actions LIKE '%warn%', 1, 0)) -... |
5 years ago |
USE cswiki_p;
SELECT afl_filter, SUM(IF(afl_actions LIKE '%warn%', 1, 0)) -... |
5 years ago |
USE cswiki_p;
SELECT afl_filter, SUM(IF(afl_actions LIKE '%warn%', 1, 0)) /... |
5 years ago |
USE cswiki_p;
SELECT afl_filter, SUM(IF(afl_actions LIKE '%warn%', 1, 0)) /... |
5 years ago |
USE cswiki_p;
/*SELECT afl_filter, SUM(IF(afl_actions LIKE '%warn%', 1, 0))... |
5 years ago |
USE cswiki_p;
/*SELECT afl_filter, SUM(IF(afl_actions LIKE '%warn%', 1, 0))... |
5 years ago |
USE cswiki_p;
SELECT afl_filter, SUM(IF(afl_actions LIKE '%warn%', 1, 0)) /... |
5 years ago |
USE cswiki_p;
SELECT afl_filter, SUM(IF(afl_actions LIKE '%warn%', 1, 0)) /... |
5 years ago |
USE cswiki_p;
SELECT afl_filter, SUM(IF(afl_actions LIKE '%warn%', 1, 0)) /... |
5 years ago |
USE cswiki_p;
SELECT afl_filter, SUM(IF(afl_actions LIKE '%warn%', 1, 0)) /... |
5 years ago |
USE cswiki_p;
SELECT afl_filter, SUM(IF(afl_actions LIKE '%warn%', 1, 0)) /... |
5 years ago |
USE cswiki_p;
SELECT afl_filter, afl_actions, COUNT(*) FROM abuse_filter_log... |
5 years ago |
USE cswiki_p;
SELECT afl_actions, COUNT(*) FROM abuse_filter_log GROUP BY... |
5 years ago |
USE cswiki_p;
SELECT afl_actions, COUNT(*) FROM abuse_filter_log WHERE... |
5 years ago |
USE cswiki_p;
SELECT * FROM abuse_filter_log ORDER BY afl_timestamp DESC... |
5 years ago |
USE cswiki_p;
SELECT * FROM abuse_filter_log ORDER BY afl_timestamp DESC LIMIT 25; |
5 years ago |
blank query |
5 years ago |
USE cswiki_p;
SELECT * FROM recentchanges WHERE rc_title =... |
5 years ago |
USE cswiki_p;
SELECT * FROM recentchanges WHERE rc_title =... |
6 years ago |
USE cswiki_p;
SELECT * FROM recentchanges WHERE rc_timestamp >... |
6 years ago |
USE cswiki_p;
SELECT * FROM recentchanges WHERE rc_timestamp > 20170630115000; |
6 years ago |