Query Run
USE commonswiki_p; SELECT LEFT(img_timestamp, 4) as `year`, COUNT(*) FROM... 4 years ago
USE commonswiki_p; SELECT LEFT(img_timestamp, 4), COUNT(*) FROM image GROUP... 4 years ago