Untitled query #80503

SQL

SELECT
  actor_name AS username,
  COUNT(*) AS count
FROM
  ukwiki_p.page
JOIN
  ukwiki_p.revision
ON
  page_id = rev_page
JOIN
  ukwiki_p.actor
ON
  rev_actor = actor_id
WHERE
  page_namespace = 10 -- Namespace 10 represents template namespace
  AND page_title = 'повідомлення_ЧЗВ' -- Template name
  AND rev_timestamp BETWEEN '2023-01-01 00:00:00' AND '2023-12-31 23:59:59' -- Limit revisions to 2023
  AND rev_text_id IN (
    SELECT
      rev_text_id
    FROM
      ukwiki_p.revision
    WHERE
      rev_text LIKE '%автор=%' -- Check if the revision contains the parameter 'автор'
  )
GROUP BY
  username;
SQL

Checking query status...
