| SELECT *
FROM recentchanges
WHERE LEFT(rc_timestamp, 4) = '2023'
AND... |
1 year ago |
| SELECT *
FROM recentchanges
WHERE LEFT(rc_timestamp, 4) = '2023'
AND... |
1 year ago |
| SELECT LEFT(rc_timestamp, 6) AS yyyymm, COUNT(*) AS edits, COUNT(DISTINCT... |
1 year ago |
| SELECT *
FROM recentchanges
WHERE LEFT(rc_timestamp, 4) = '2023'
AND... |
1 year ago |
| SELECT LEFT(rc_timestamp, 6) AS yyyymm, COUNT(*) AS edits, COUNT(DISTINCT... |
1 year ago |
| SELECT LEFT(rc_timestamp, 6) AS yyyymm, COUNT(DISTINCT rc_title) AS... |
1 year ago |
| SELECT LEFT(rc_timestamp, 6) AS yyyymm #, COUNT(DISTINCT rc_title) AS... |
1 year ago |
| SELECT LEFT(rc_timestamp, 6) AS yyyymm #, COUNT(DISTINCT rc_title) AS... |
1 year ago |
| SELECT LEFT(rc_timestamp, 6) AS yyyymm, COUNT(DISTINCT rc_title) AS... |
1 year ago |
| USE enwiki_p;
SELECT LEFT(rc_timestamp, 8) AS yyyymmdd, COUNT(DISTINCT... |
1 year ago |
