KeFe által létrehozott lapok

SQL

select page.page_title, revision.rev_timestamp
from page
inner join revision on revision.rev_page = page.page_id
inner join actor on revision.rev_actor = actor.actor_id
where page.page_is_redirect = 0 # exclude redirects
and revision.rev_id = (select min(revision2.rev_id) from revision as revision2 where revision2.rev_page = page.page_id) # first revision
and actor.actor_name = "KeFe" # created by this user
and page.page_namespace = 0 # article namespace only
and page.page_title not like "%(egyértelműsítő_lap)" # exclude disambiguation pages
order by revision.rev_timestamp desc;
SQL

Checking query status...
