01/2007
07/2014
SELECT SUBSTRING_INDEX(`image`, '.’, -1) AS `extension`, COUNT(*) AS `amount` FROM `stats` GROUP BY `extension` ORDER BY `amount` DESC
jpeg
jpg