incelenmemiş sayfalar

SQL

USE trwiki_p;
select now();
select page_id, page_title as baslik, page_is_new as y, page_len as len
, rev_comment, rev_deleted
, concat("tr.wikipedia.org/w/index.php?curid=",page_id) as url
, concat("tr.wikipedia.org/w/index.php?oldid=",page_latest) as urlrev
from page left join flaggedrevs on fr_page_id = page_id left join revision_userindex on rev_id = page_latest

where page_namespace =0 and page_is_redirect = 0 and fr_tags is null and rev_comment is null
-- and page_id not in (select pp.page_id from page pp join logging_userindex  on log_title = pp.page_title where log_action ='delete')
-- order by page_latest
limit 100;
select now();
SQL

Checking query status...
