| SELECT rev_user_text, SUM(IF(rev_timestamp < '20150507000000', 1, 0)) AS a,... |
5 years ago |
| SELECT rev_user_text, SUM(IF(rev_timestamp < '20150507000000', 1, 0)) AS a,... |
5 years ago |
| SELECT rev_user_text, SUM(IF(rev_timestamp < '20150507000000', 1, 0)) AS a,... |
5 years ago |
| SELECT rev_user_text, SUM(IF(rev_timestamp < '20150507000000', 1, 0)) AS a,... |
5 years ago |
| SELECT rev_user_text, SUM(IF(rev_timestamp < '20150507000000', 1, 0)) AS a,... |
8 years ago |
| DESCRIBE user;
SELECT rev_user_text, SUM(IF(rev_timestamp <=... |
8 years ago |
| DESCRIBE user;
SELECT * FROM (SELECT * FROM user WHERE user_editcount > 500... |
8 years ago |
| DESCRIBE user;
SELECT * FROM (SELECT * FROM user WHERE user_editcount > 500... |
8 years ago |
| /*SELECT * FROM (SELECT * FROM user WHERE user_editcount > 500) AS... |
8 years ago |
| /*SELECT * FROM (SELECT * FROM user WHERE user_editcount > 500) AS... |
8 years ago |
| SELECT rev_user_text, COUNT(*) FROM enwiki_p.revision GROUP BY rev_user_text; |
8 years ago |
| SELECT rev_user_text, COUNT(*) FROM enwiki_p.revision GROUP BY rev_user_text; |
8 years ago |
| SELECT u.user_id as user_id, count(u.user_id) as editcount
FROM... |
8 years ago |
