Untitled query #73015

SQL

SELECT
  CONCAT("[[:Категория:", REPLACE(page_title, "_", " " ), "|", REPLACE(page_title, "_", " " ), "]]") AS Category,
  actor_name AS Name
FROM page
LEFT JOIN `revision`
ON page_id = rev_page AND (SELECT rev_id FROM revision WHERE page_id = rev_page ORDER BY rev_id DESC LIMIT 1) = rev_id
LEFT JOIN `actor`
ON rev_actor = actor_id
WHERE page_namespace = 14
AND page_is_new = 0
AND page_is_redirect = 0
AND (actor_name LIKE "%:%" OR actor_name REGEXP '^[0-9]{1,3}[.][0-9]{1,3}[.][0-9]{1,3}[.][0-9]{1,3}$')
AND rev_actor != (SELECT rev_actor FROM revision WHERE page_id = rev_page ORDER BY rev_id ASC LIMIT 1)

LIMIT 100
SQL

Checking query status...
