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