Untitled query #88239

SQL

SELECT p.page_title
FROM page p
JOIN revision r ON p.page_id = r.rev_page
JOIN actor a ON r.rev_actor = a.actor_id
JOIN (
    SELECT rev_page, MIN(rev_id) AS first_rev_id
    FROM revision
    GROUP BY rev_page
) first_revisions ON r.rev_page = first_revisions.rev_page AND r.rev_id = first_revisions.first_rev_id
WHERE p.page_namespace = 0
  AND p.page_is_redirect = 0
  AND a.actor_name = 'Jevansen'

AخA
 
SELECT p.page_titleFROM page pJOIN revision r ON p.page_id = r.rev_pageJOIN actor a ON r.rev_actor = a.actor_idJOIN (    SELECT rev_page, MIN(rev_id) AS first_rev_id    FROM revision    GROUP BY rev_page) first_revisions ON r.rev_page = first_revisions.rev_page AND r.rev_id = first_revisions.first_rev_idWHERE p.page_namespace = 0  AND p.page_is_redirect = 0  AND a.actor_name = 'Jevansen'

SQL

Checking query status...