incelenmemiş sayfalar

SQL

USE trwiki_p;
set @ddd = DATE_add(now(), INTERVAL -90 DAY);

select 
concat("[[",replace(page_title,"_"," "),"]]") as basliklar  -- group durumunda group_concat
, page_is_new as y, page_len as len
, concat("http://tr.wikipedia.org/w/index.php?redirect=no&curid=",page_id) as url
, rev_user_text as ilk_kullanici

, user_editcount as ec
-- , count(*), sum(datediff(now(),rev_timestamp)) /*
, (datediff(now(),rev_timestamp)) 
-- */
as kac_gun_top
from page left join flaggedrevs on fr_page_id = page_id 
join revision_userindex on rev_page = page_id
left join user on user_id = rev_user

where page_namespace = 0 and rev_parent_id = 0
and rev_timestamp < @ddd
-- and rev_user > 0
-- and (user_name is null OR user_name not in ('Etrüsk', 'Maderibeyza', 'Alperx', 'Erdall'))
and user_name in ('Etrüsk')
and page_is_redirect = 0 
and fr_tags is null 
/*and page_id  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"
                     )
                    )
                    
-- group by user_name
-- */
order by kac_gun_top desc

;
SQL

Checking query status...
