| SELECT
SUBSTR(log_timestamp, 1, 6) AS bucket,
COUNT(DISTINCT... |
3 years ago |
| USE wikidatawiki_p;
SELECT
SUBSTR(log_timestamp, 1, 6) AS bucket,
... |
3 years ago |
| USE wikidatawiki_p;
SELECT
SUBSTR(log_timestamp, 1, 6) AS bucket,
... |
4 years ago |
| USE wikidatawiki_p;
SELECT
SUBSTR(log_timestamp, 1, 6) AS bucket,
... |
4 years ago |
| USE wikidatawiki_p;
SELECT
SUBSTR(log_timestamp, 1, 6) AS bucket,
... |
4 years ago |
| USE wikidatawiki_p;
SELECT
SUBSTR(log_timestamp, 1, 6) AS bucket,
... |
4 years ago |
| USE wikidatawiki_p;
SELECT
SUBSTR(log_timestamp, 1, 6) AS bucket,
... |
5 years ago |
| USE wikidatawiki_p;
SELECT
SUBSTR(log_timestamp, 1, 6) AS bucket,
... |
6 years ago |
| USE wikidatawiki_p;
SELECT
SUBSTR(ROUND(log_timestamp, -8), 1, 6) AS... |
6 years ago |
| USE wikidatawiki_p;
SELECT
SUBSTR(ROUND(log_timestamp, -8), 1, 7) AS... |
6 years ago |
| USE wikidatawiki_p;
SELECT
SUBSTRING(ROUND(log_timestamp, -8) FROM 1... |
6 years ago |
| USE wikidatawiki_p;
-- bin 0 objects were not items, e.g. [[wikidata:Main... |
6 years ago |
| USE wikidatawiki_p;
-- bin 0 objects were not items, e.g. [[wikidata:Main... |
6 years ago |
