Code:

SELECT articles.id, articles.title, articles.view_count FROM articles WHERE articles.views.date_created = %LAST_YEAR% ORDER BY articles.view_count DESC

Untitled