incelenmemiş sayfalar

SQL

USE trwiki_p;

select page_id
, concat("[[",replace(page_title,"_"," "),"]]") as baslik
, page_is_new as y, page_len as len
, concat("http://tr.wikipedia.org/w/index.php?redirect=no&curid=",page_id) as url
, user_name as ilk_kullanici
, datediff(now(),rev_timestamp) as kac_gun
, user_editcount as ec
-- , count(*)
-- , concat("<nowiki>",rev_comment,"</nowiki>") as yorum
-- , rev_deleted 
,group_concat(ug_group) as gr
-- ,concat(log_user, " ... ", log_comment, " ... ", log_deleted, " ... ", log_params) as logilogi
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
left join user_groups on ug_user= rev_user
-- left join logging_userindex on log_page = page_id

where page_namespace = 0 and rev_parent_id = 0
and user_name not in ('Etrüsk', 'Maderibeyza', 'Alperx', 'Erdall', 'Krkzn', 'Sabri76', 'Mach')
-- and user_name in ('Mirada')
and page_is_redirect = 0 
and fr_tags is null 
-- and log_action = 'delete'
-- 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')
and page_id not in ((select cl1.cl_from from categorylinks cl1 where cl1.cl_to rlike ('köy_taslakları')
                     OR cl1.cl_to rlike "köyler"  OR cl1.cl_to rlike "köyleri"
                     OR cl1.cl_to rlike ('mahalle_taslakları')
                     OR cl1.cl_to rlike "mahalleler"  OR cl1.cl_to rlike "mahalleleri"
                     )
                    )
and datediff(now(),rev_timestamp)>=20
                                   
group by rev_id 

-- limit 500
;
SQL

Checking query status...
