Retrieve a list of the most popular articles on "cricket" within a given date range.

SQL

-- Selects the article titles and their respective revision counts from the database.
SELECT
  page_title AS article_title,           -- Renames 'page_title' as 'article_title' for clarity.
  COUNT(rev_id) AS revision_count         -- Counts the number of revisions and renames it as 'revision_count'.
FROM page                                  -- Specifies the 'page' table as the source of data.
JOIN revision                             -- Joins the 'page' and 'revision' tables based on common IDs.
ON page_id = rev_page
WHERE page_namespace = 0                  -- Filters for articles in the main namespace (namespace 0).
  AND page_title LIKE '%cricket%'         -- Filters for articles with titles containing 'cricket'.
  AND rev_timestamp BETWEEN '2022-01-01 00:00:00' AND '2023-12-31 23:59:59'  -- Filters for revisions within the date range.
GROUP BY page_title                       -- Groups the results by article title for aggregation.
ORDER BY revision_count DESC              -- Orders the results in descending order of revision counts.
LIMIT 1000;                               -- Limits the output to the top 1000 articles.
SQL

Checking query status...
