المقالة ذات الترتيب المحدد 3

SQL

use arwiki_p;
/*select * from archive 
  where ar_parent_id = 0
  and ar_namespace = 0
  limit 100;*/

SELECT * FROM (
  SELECT p.page_title, r.rev_timestamp as time
  FROM page p
  join revision r 
  on p.page_id=r.rev_page
  WHERE p.page_namespace=0
  and p.page_is_redirect=0 
  and r.rev_parent_id=0
  UNION ALL
  select ar_title, ar_timestamp as time from archive 
  where ar_parent_id = 0
  and ar_namespace = 0
  and ar_timestamp not like "2001%"
) e
order by time asc
limit 100000;

/*
(SELECT p.page_title, r.
FROM page p
join revision r 
on p.page_id=r.rev_page
WHERE p.page_namespace=0
and p.page_is_redirect=0 
and r.rev_parent_id=0 
ORDER BY rev_timestamp asc);

(select ar_title from archive
where ar_parent_id = 0
and ar_namespace = 0
ORDER BY ar_timestamp asc);*/
SQL

Checking query status...
