incelenmemiş sayfalar

SQL

USE trwiki_p;

select page_id, page_title as baslik, page_is_new as y, page_len as len
, concat("tr.wikipedia.org/w/index.php?redirect=no&curid=",page_id) as url
-- , rev_comment, rev_deleted
, user_name as page_creator
from page left join flaggedrevs on fr_page_id = page_id 
join revision_userindex on rev_page = page_id
join user on user_id = rev_user

where page_namespace = 0 
and rev_parent_id = 0
-- and user_name in ('Mirada')
-- and page_is_redirect = 1 
and fr_tags is null 
-- and length(rev_comment) > 0
-- 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 rev_user, page_latest
-- , page_latest
limit 100
;
SQL

Checking query status...
