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
JOIN
  ukwiki_p.slots
ON
  rev_id = slot_revision_id
JOIN
  ukwiki_p.content
ON
  slot_content_id = content_id
WHERE

   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 content_address LIKE '%автор=%' -- Check if the content contains the parameter 'автор='
GROUP BY
  username;
SQL

Checking query status...
