| SELECT
AVG(num_revisions) AS average_num_revisions_per_day,
... |
8 months ago |
| SELECT
AVG(num_revisions) AS average_num_revisions,
... |
8 months ago |
| SELECT
AVG(num_revisions) AS average_num_revisions,
... |
8 months ago |
| SELECT
AVG(num_revisions) AS average_num_revisions,
... |
8 months ago |
| SELECT
AVG(num_revisions) AS average_num_revisions,
... |
8 months ago |
|
SELECT
day_portion,
COUNT(rc_timestamp) AS num_revisions,
... |
8 months ago |
| SELECT AVG(num_revisions) AS... |
8 months ago |
| SELECT
AVG(num_revisions) AS avg_num_revisions_per_day,
... |
8 months ago |
|
SELECT
day_portion,
COUNT(rc_timestamp) AS num_revisions,
... |
8 months ago |
| SELECT
AVG(num_revisions) AS... |
8 months ago |
| SELECT AVG(num_revisions) AS... |
8 months ago |
| SELECT AVG(num_revisions) AS... |
8 months ago |
| SELECT AVG(num_revisions) AS... |
8 months ago |
|
SELECT
SUBSTRING(rc.rc_timestamp, 7, 2) AS day_portion,
... |
8 months ago |
| SELECT AVG(num_revisions) AS... |
8 months ago |
| SELECT
day_portion,
COUNT(rc_timestamp) AS... |
8 months ago |
| SELECT
day_portion,
COUNT(rc_timestamp) AS... |
8 months ago |
|
SELECT
day_portion,
COUNT(rc_timestamp) AS avg_num_revisions,
... |
8 months ago |
| SELECT AVG(avg_num_revisions) AS... |
8 months ago |
| SELECT AVG(avg_num_revisions) AS... |
8 months ago |
| SELECT AVG(avg_num_revisions) AS... |
8 months ago |
| SELECT AVG(avg_num_revisions) AS... |
8 months ago |
| SELECT AVG(avg_num_revisions) AS... |
8 months ago |
| SELECT AVG(avg_num_revisions) AS... |
8 months ago |
| SELECT AVG(avg_num_revisions) AS... |
8 months ago |
| SELECT AVG(avg_num_revisions) AS... |
8 months ago |
| #SELECT AVG(avg_num_revisions) AS... |
8 months ago |
| #SELECT AVG(avg_num_revisions) AS... |
8 months ago |
| SELECT AVG(avg_num_revisions) AS... |
8 months ago |
| SELECT AVG(avg_num_revisions) AS... |
8 months ago |
| SELECT AVG(avg_num_revisions) AS... |
8 months ago |
| SELECT AVG(avg_num_revisions) AS... |
8 months ago |
| SELECT AVG(avg_num_revisions) AS... |
8 months ago |
| SELECT AVG(avg_num_revisions) AS... |
8 months ago |
| SELECT AVG(avg_num_revisions) AS... |
8 months ago |
| SELECT AVG(avg_num_revisions) AS... |
8 months ago |
| SELECT AVG(avg_num_revisions) AS... |
8 months ago |
| SELECT AVG(avg_num_revisions) AS... |
8 months ago |
| SELECT
day_portion,
COUNT(rc_timestamp) AS num_revisions,
... |
8 months ago |
| SELECT
day_portion,
COUNT(rc_timestamp) AS num_revisions,
... |
8 months ago |
| SELECT
COUNT(rc_timestamp) AS num_revisions,
... |
8 months ago |
| SELECT
COUNT(rc_bot) AS num_revisions,
AVG(true_comment_length) AS... |
8 months ago |
| SELECT
COUNT(rc_bot) AS num_revisions,
AVG(true_comment_length) AS... |
8 months ago |
|
SELECT
rc.rc_bot,
rc.rc_timestamp,
... |
8 months ago |
|
SELECT
rc.rc_bot,
rc.rc_timestamp,
... |
8 months ago |
| SELECT
DATE_FORMAT(CONVERT_TZ(FROM_UNIXTIME(rc_timestamp), 'UTC',... |
8 months ago |
| SELECT
DATE_FORMAT(CONVERT_TZ(FROM_UNIXTIME(rc_timestamp), 'UTC',... |
8 months ago |
| SELECT
DATE_FORMAT(CONVERT_TZ(FROM_UNIXTIME(rc_timestamp), 'UTC',... |
8 months ago |
| SELECT
DATE_FORMAT(FROM_UNIXTIME(UNIX_TIMESTAMP(rc_timestamp,... |
8 months ago |
| SELECT
DATE_FORMAT(FROM_UNIXTIME(rc_timestamp), '%Y-%m-%d') AS day,
... |
8 months ago |
| #SELECT
# COUNT(rc_bot) AS num_revisions,
# AVG(true_comment_length)... |
8 months ago |
| #SELECT
# COUNT(rc_bot) AS num_revisions,
# AVG(true_comment_length)... |
8 months ago |
| #SELECT
# COUNT(rc_bot) AS num_revisions,
# AVG(true_comment_length)... |
8 months ago |
| #SELECT
# COUNT(rc_bot) AS num_revisions,
# AVG(true_comment_length)... |
8 months ago |
| #SELECT
# COUNT(rc_bot) AS num_revisions,
# AVG(true_comment_length)... |
8 months ago |
| #SELECT
# COUNT(rc_bot) AS num_revisions,
# AVG(true_comment_length)... |
8 months ago |
| #SELECT
# COUNT(rc_bot) AS num_revisions,
# AVG(true_comment_length)... |
8 months ago |
| #SELECT
# COUNT(rc_bot) AS num_revisions,
# AVG(true_comment_length)... |
8 months ago |
| SELECT
COUNT(rc_bot) AS num_revisions,
AVG(true_comment_length) AS... |
8 months ago |
| #SELECT
# COUNT(rc_bot) AS num_revisions,
# AVG(true_comment_length) AS... |
8 months ago |
| SELECT
COUNT(rc_bot) AS num_revisions,
AVG(true_comment_length) AS... |
8 months ago |
| SELECT
COUNT(rc_bot) AS num_revisions,
AVG(true_comment_length) AS... |
8 months ago |
| SELECT
COUNT(rc_bot) AS num_revisions,
AVG(true_comment_length) AS... |
8 months ago |
| SELECT
COUNT(rc_bot) AS num_revisions,
AVG(true_comment_length) AS... |
8 months ago |
| #SELECT
# COUNT(rc_bot) AS num_revisions,
# AVG(comment_length) AS... |
8 months ago |
| SELECT
COUNT(rc_bot) AS num_revisions,
AVG(comment_length) AS... |
8 months ago |
| SELECT
COUNT(rc_bot) AS num_revisions,
AVG(comment_length) AS... |
8 months ago |
|
SELECT
cr.comment_text,
LENGTH(cr.comment_text) AS... |
8 months ago |
|
SELECT
cr.comment_text,
LENGTH(cr.comment_text) AS... |
8 months ago |
|
SELECT
cr.comment_text,
LENGTH(cr.comment_text) AS... |
8 months ago |
|
SELECT
rc.*,
cr.comment_text,
... |
8 months ago |
|
SELECT
rc.rc_bot,
cr.comment_text,
... |
8 months ago |
|
SELECT
rc.rc_bot,
cr.comment_text,
... |
8 months ago |
|
SELECT
rc.rc_bot,
cr.comment_text,
... |
8 months ago |
|
SELECT
rc.rc_bot,
cr.comment_text,
... |
8 months ago |
|
SELECT
SELECT
rc.rc_bot,
cr.comment_text,
... |
8 months ago |
|
SELECT
rc.rc_bot,
cr.comment_text,
... |
8 months ago |
|
SELECT
rc.rc_bot,
cr.comment_text
... |
8 months ago |
|
SELECT
rc.rc_bot,
cr.comment_text
FROM
... |
8 months ago |
| SELECT
cr.comment_text
FROM (
SELECT
rc.rc_bot,
... |
8 months ago |
| SELECT
COUNT(rc_bot) AS num_revisions,
AVG(comment_length) AS... |
8 months ago |
| SELECT
COUNT(rc.rc_bot) AS num_revisions,
... |
8 months ago |
| SELECT
COUNT(rc.rc_bot) AS num_revisions,
... |
8 months ago |
| SELECT
COUNT(rc.rc_bot) AS num_revisions,
... |
8 months ago |
| SELECT
COUNT(rc.rc_bot) AS num_revisions,
... |
8 months ago |
| SELECT * FROM recentchanges LIMIT 80 |
8 months ago |
| SELECT * FROM recentchanges LIMIT 30 |
8 months ago |
| SHOW COLUMNS FROM comment_recentchanges |
8 months ago |
| SHOW COLUMNS FROM recentchanges |
8 months ago |
| SELECT rc_bot FROM recentchanges LIMIT 5; |
8 months ago |
| SELECT rc_bot FROM recentchanges; |
8 months ago |
| SHOW COLUMNS FROM recentchanges |
8 months ago |
| SHOW COLUMNS FROM comment_recentchanges |
8 months ago |
| SHOW COLUNNS FROM comment_recentchanges |
8 months ago |
