test - Quarry

SQL

select page.page_title,page.page_id,revision.rev_page ,revision.rev_timestamp,(select r.rev_page from revision  r where r.rev_page = page.page_id  order by r.rev_timestamp asc limit 1 ) from pagelinks 
inner join page
on page.page_id = pagelinks.pl_from
inner join revision
on page.page_id = revision.rev_page

where pagelinks.pl_title="ألعاب_فيديو" and pagelinks.pl_from_namespace=0 and pagelinks.pl_namespace = 100
limit 10

#select * from revision  where revision.rev_page = 10938 order by rev_timestamp asc limit 1
 #(select r.rev_page from revision as r where r.rev_page = page.page_id  order by r.rev_timestamp asc limit 1 )
SQL

Checking query status...
