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...
