Untitled query #80503

SQL

SELECT
  tl_title AS username,
  COUNT(*) AS count
FROM
  ukwiki_p.templateusage
JOIN
  ukwiki_p.page
ON
  tl_from = page_id
JOIN
  ukwiki_p.revision
ON
  rev_id = tl_revid
WHERE
  tl_namespace = 10 -- Namespace 10 represents template namespace
  AND tl_title = 'повідомлення_ЧЗВ' -- Template name
  AND tl_params LIKE '%автор=%' -- Check if the template has the parameter 'автор'
  AND tl_params LIKE CONCAT('%автор=', rev_user_text) -- Check if the 'автор' parameter matches the username
  AND rev_timestamp BETWEEN '20230101000000' AND '20231231235959' -- Limit revisions to 2023
GROUP BY
  tl_title, rev_user_text;
SQL

Checking query status...
