Test - Quarry

SQL

-- Get a list of usernames from wikitext on ckbwiki

SELECT
  DISTINCT
  -- Extract usernames using regular expression and substring functions
  SUBSTRING(
    REGEXP_REPLACE(old_text, '\\[\\[User:([^|]+)\\|([^\\]]+)\\]\\]', '\\1'),
    1
  ) AS username
FROM
  page
  JOIN revision ON rev_id = page_latest
  JOIN text ON old_id = rev_text_id
WHERE
  -- Replace 'Page_title' with the relevant page title or namespace
  page_title = 'بەکارھێنەر:Aram/تاقیکردنەوە'
  AND old_text LIKE '%[[User:%|%]]%'; -- Ensure the wikitext contains the expected pattern
SQL

Checking query status...
