Select all pages created by actor with id

Fork of Select all pages created by actor with id by NikiWiki

This query is marked as a draft This query has been published by Dnshitobu.

SQL

select
        page_title
from
        page
        join revision on page_id=rev_page
        join revision_actor_temp on revision_actor_temp.revactor_rev=revision.rev_id
        join actor on actor.actor_id=revision_actor_temp.revactor_actor
where
        revactor_actor=16
        and rev_parent_id=0
        and page.page_namespace=0
        and page.page_is_redirect=0

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...