SELECT
LEFT(rev_timestamp, 6) AS edit_month,
COUNT(*) AS edit_count
FROM... |
2 weeks ago |
SELECT
LEFT(rev_timestamp, 6) AS edit_month,
COUNT(*) AS edit_count
FROM... |
2 weeks ago |
SELECT
LEFT(rev_timestamp, 6) AS edit_month,
COUNT(*) AS edit_count
FROM... |
2 weeks ago |
SELECT
LEFT(rev_timestamp, 6) AS edit_month,
COUNT(*) AS edit_count
FROM... |
2 weeks ago |
SELECT
CONCAT(YEAR(FROM_UNIXTIME(rev_timestamp)), '-',... |
2 weeks ago |
SELECT
rev_timestamp AS edit_date,
COUNT(*) AS edit_count
FROM... |
2 weeks ago |
SELECT
DATE(FROM_UNIXTIME(rev_timestamp)) AS edit_date,
COUNT(*) AS... |
2 weeks ago |
SELECT
YEAR(rev_timestamp) AS year,
COUNT(*) AS edit_count
FROM... |
2 weeks ago |