Untitled query #79411

SQL

SELECT *
FROM page p
INNER JOIN category c
ON p.page_title = c.cat_title
INNER JOIN (
  SELECT rev_page, MIN(rev_id) AS min_rev_id, MAX(rev_id) AS max_rev_id, COUNT(rev_id) AS rev_count
  FROM revision
  GROUP BY rev_page) rw
ON p.page_id = rw.rev_page
INNER JOIN revision rf
ON rw.rev_page = rf.rev_page
AND rw.min_rev_id = rf.rev_id
INNER JOIN actor a
ON rf.rev_actor = a.actor_id
WHERE p.page_namespace = 14
AND c.cat_pages = 0
AND c.cat_subcats = 0
AND c.cat_files = 0
AND p.page_is_new = 1
AND p.page_is_redirect = 0
SQL

Checking query status...
