Untitled query #80138

SQL

SELECT *
FROM page p
INNER JOIN category cat
ON p.page_title = cat.cat_title
INNER JOIN (
  SELECT rev_page, MIN(rev_id) AS first_rev_id, MAX(rev_id) AS last_rev_id, COUNT(rev_id) AS rev_count
  FROM revision
  GROUP BY rev_page) rev_group
ON p.page_id = rev_group.rev_page
INNER JOIN revision first_rev
ON rev_group.rev_page = first_rev.rev_page
AND rev_group.first_rev_id = first_rev.rev_id
INNER JOIN actor first_actor
ON first_rev.rev_actor = first_actor.actor_id
WHERE p.page_namespace = 14
AND cat.cat_pages = 0
AND cat.cat_subcats = 0
AND cat.cat_files = 0
ORDER BY first_actor.actor_name
SQL

Checking query status...
