SELECT SUM(1) AS edits, SUM(rc_patrolled) AS patrolled, SUM(IF(page_latest =... |
3 years ago |
SELECT SUM(1) AS edits, SUM(rc_patrolled) AS patrolled, SUM(IF(page_latest =... |
3 years ago |
SELECT SUM(1) AS edits, SUM(rc_patrolled) AS patrolled, SUM(IF(page_latest =... |
3 years ago |
USE wikidatawiki_p;
SELECT SUM(1) AS edits, SUM(rc_patrolled) AS patrolled,... |
5 years ago |
USE wikidatawiki_p;
SELECT SUM(1) AS edits, SUM(rc_patrolled) AS patrolled,... |
6 years ago |
USE wikidatawiki_p;
SELECT SUM(1) AS edits, SUM(rc_patrolled) AS patrolled,... |
6 years ago |
USE wikidatawiki_p;
SELECT SUM(1) AS edits, SUM(rc_patrolled) AS patrolled,... |
6 years ago |
USE wikidatawiki_p;
SELECT SUM(1) AS edits, SUM(rc_patrolled) AS patrolled,... |
6 years ago |
USE wikidatawiki_p;
SELECT SUM(1) AS edits, SUM(rc_patrolled) AS patrolled,... |
6 years ago |
USE wikidatawiki_p;
SELECT SUM(1), SUM(rc_patrolled), SUM(IF(page_latest =... |
6 years ago |
USE wikidatawiki_p;
SELECT SUM(1), SUM(rc_patrolled), SUM(IF(page_latest =... |
6 years ago |
USE wikidatawiki_p;
/*SELECT SUM(1), SUM(rc_patrolled), SUM(IF(page_latest =... |
6 years ago |
USE wikidatawiki_p;
/*SELECT SUM(1), SUM(rc_patrolled), SUM(IF(page_latest =... |
6 years ago |
USE wikidatawiki_p;
SELECT SUM(1), SUM(rc_patrolled), SUM(IF(page_latest =... |
6 years ago |
USE wikidatawiki_p;
SELECT SUM(1), SUM(rc_patrolled), SUM(IF(page_latest =... |
6 years ago |
USE wikidatawiki_p;
SELECT SUM(1), SUM(rc_patrolled), SUM(IF(page_latest =... |
6 years ago |
USE wikidatawiki_p;
SELECT SUM(1), SUM(rc_patrolled) FROM recentchanges
LEFT... |
6 years ago |
USE wikidatawiki_p;
SELECT COUNT(*) FROM recentchanges
LEFT JOIN user ON... |
6 years ago |
USE wikidatawiki_p;
#SELECT COUNT(*), COUNT(*) - SUM(IF(log_action =... |
6 years ago |
USE wikidatawiki_p;
SELECT COUNT(*), COUNT(*) - SUM(IF(log_action =... |
6 years ago |
USE wikidatawiki_p;
DESCRIBE recentchanges;
SELECT COUNT(*) -... |
6 years ago |
USE wikidatawiki_p;
#SELECT *
#FROM recentchanges
#JOIN (SELECT log_type,... |
6 years ago |
USE wikidatawiki_p;
SELECT DISTINCT rc_log_type, rc_log_action FROM... |
6 years ago |
USE wikidatawiki_p;
SELECT DISTINCT rc_log_type, rc_log_action FROM... |
6 years ago |
USE wikidatawiki_p;
SELECT DISTINCT rc_log_action FROM recentchanges WHERE... |
6 years ago |
USE wikidatawiki_p;
#SELECT DISTINCT log_action FROM logging WHERE log_type... |
6 years ago |
USE wikidatawiki_p;
SELECT DISTINCT log_action FROM logging WHERE log_type =... |
6 years ago |
USE wikidatawiki_p;
SELECT DISTINCT log_action FROM logging WHERE log_type =... |
6 years ago |
USE wikidatawiki_p;
SELECT DISTINCT log_action, log_type FROM logging WHERE... |
6 years ago |
USE wikidatawiki_p;
SELECT DISTINCT log_action, log_type FROM... |
6 years ago |
USE wikidatawiki_p;
DESCRIBE logging;
DESCRIBE recentchanges; |
6 years ago |