SELECT
      	DATE_FORMAT( create_time, "%Y-%m-01 00:00:00" ) archiveDate,
        COUNT(*) articleTotal
      FROM
        plumemo_posts
      GROUP BY DATE_FORMAT( create_time, "%Y-%m-01 00:00:00" )
      ORDER BY archiveDate DESC
    </select>```