SELECT
DAYOFWEEK(rev_timestamp) AS dow,
HOUR(rev_timestamp) AS hour,
... |
3 years ago |
SELECT
CONCAT(DAYOFWEEK(rev_timestamp), "-", HOUR(rev_timestamp)) AS... |
3 years ago |
SELECT
CONCAT(DAYOFWEEK(rev_timestamp), "-", HOUR(rev_timestamp) AS hour,
... |
3 years ago |
SELECT
DAYOFWEEK(rev_timestamp) AS dow,
HOUR(rev_timestamp) AS hour,
... |
3 years ago |
SELECT
DAYOFWEEK(rev_timestamp) AS dow,
HOUR(rev_timestamp) AS hour,
... |
3 years ago |
SELECT
DAYOFWEEK(rev_timestamp) AS dow,
COUNT(rev_id) AS edits
FROM... |
3 years ago |
SELECT
LEFT(rev_timestamp, 8) AS day,
COUNT(rev_id) AS edits
FROM... |
3 years ago |
SELECT
LEFT(rev_timestamp, 8) AS day,
COUNT(rev_id) AS edits
FROM... |
3 years ago |
SELECT
LEFT(rev_timestamp, 8) AS day,
COUNT(rev_id) AS edits
FROM... |
3 years ago |
SELECT
LEFT(rev_timestamp, 8) AS day
COUNT(rev_id) AS edits
FROM... |
3 years ago |
SELECT
LEFT(rev_timestamp, 8) AS day
COUNT(rev_id) AS edits
FROM... |
3 years ago |
SELECT
COUNT(rev_id) AS edits,
LEFT(rev_timestamp, 6) AS month
FROM... |
3 years ago |
SELECT
page_title,
COUNT(DISTINCT rev_actor) AS users
FROM revision LEFT... |
3 years ago |