Company articles by activity increase

SQL

SELECT
  cl_from,
  page_title,
  min_timestamp,
  max_timestamp,
  n_revs / TIMESTAMPDIFF(MONTH, min_timestamp, max_timestamp) AS avg_per_month,
  n_this_month - n_revs / TIMESTAMPDIFF(MONTH, min_timestamp, max_timestamp) AS increase
FROM (
SELECT
  cl_from,
  COUNT(*) AS n_revs,
  MIN(rev_timestamp) AS min_timestamp,
  MAX(rev_timestamp) AS max_timestamp,
  SUM(CASE WHEN rev_timestamp >= '20220501000000' THEN 1 ELSE 0 END) AS n_this_month
FROM categorylinks
INNER JOIN revision ON revision.rev_page = categorylinks.cl_from
WHERE
TRUE
AND cl_to LIKE 'American\_companies\_established\_in\_%'
AND cl_type = 'page'
GROUP BY cl_from
) AS q
INNER JOIN page ON page.page_id = q.cl_from
WHERE
TRUE
AND n_this_month > 0
ORDER BY increase DESC
SQL

Checking query status...
