Untitled query #77616

SQL

SELECT
  CONCAT('# [[مستخدم:', a.page_title, ']]') AS "الصفحة",
  actor.actor_name AS "منشئ الصفحة",
  r.rev_timestamp AS "تاريخ الإنشاء"
FROM revision AS r
INNER JOIN actor ON actor.actor_id = r.rev_actor
INNER JOIN page AS a ON a.page_id = r.rev_page AND a.page_namespace = 2
WHERE r.rev_parent_id = 0
AND page_is_redirect = 0
AND a.page_title NOT LIKE "%/%"
AND a.page_title NOT IN (
  SELECT REPLACE(ac.actor_name," ","_")
  FROM actor AS ac
)
GROUP BY a.page_id
ORDER BY r.rev_timestamp DESC;
SQL

Checking query status...
