مقالات تم مراجعتها ومازلت موجودة في ويكيبيديا:طلبات مراجعة المقالات

SQL

/*
select page_title from page
where page.page_is_redirect = 0
and page.page_namespace = 0
and page_id in (select fp_page_id from flaggedpages where fp_page_id = page_id)
and page_id in (select cl_from from categorylinks where cl_to like "جميع_المقالات_غير_المراجعة");
*/
/*
select pl_title from pagelinks
where pl_from = 3421494
and pl_from_namespace = 4
and pl_namespace = 0
*/
select * from flaggedrevs 
inner join user on user.user_id = fr.user_id
where fr_page_id = 9251362
order by fr_timestamp asc
limit 1
/*
select REPLACE(page_title,"_"," ") from page
where page.page_is_redirect = 0
and page.page_namespace = 0
and page_id in (select fp_page_id from flaggedpages where fp_page_id = page_id)
and page_title in (
  select pl_title from pagelinks
  where pl_from = 3421494
  and pl_from_namespace = 4
  and pl_namespace = 0
);
*/

SQL

Checking query status...