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

SQL

use arwiki_p;

SELECT * FROM (
  SELECT p.page_title
  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 from archive
  where ar_parent_id = 0
  and ar_namespace = 0
) e
order by e.rev_timestamp asc
limit 10;

/*
(SELECT p.page_title
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...