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