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
WHERE page_namespace = 14
AND page_is_new = 0
AND page_is_redirect = 0
AND EXISTS((SELECT rev_actor FROM revision WHERE page_id = rev_page AND LIMIT 1))


-- LEFT JOIN `revision`
-- ON page_id = rev_page 
-- LEFT JOIN `actor`
-- ON rev_actor = actor_id
-- 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...
