Untitled query #73015

SQL

SELECT
  CONCAT("<a href='https://ru.wikinews.org/wiki/Категория:", page_title, "'>Click</a>") AS Category,
  actor_name AS Name
FROM page
LEFT JOIN revision
ON page_id = rev_page #AND rev_actor = (SELECT rev_actor FROM revision WHERE page_id = rev_page LIMIT 1)
LEFT JOIN actor
ON rev_actor = actor_id
WHERE page_namespace = 14
AND page_is_new = 0
AND page_is_redirect = 0
AND page_id = rev_page
AND (actor_name LIKE "%:%" OR actor_name REGEXP '^[0-9]{1,3}[.][0-9]{1,3}[.][0-9]{1,3}[.][0-9]{1,3}$')
LIMIT 100
SQL

Checking query status...
