SQL
x
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(*)
-- , rev_comment, rev_deleted
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 not in ('Etrüsk', 'Maderibeyza', 'Alperx', 'Erdall', 'Krkzn', 'Sabri76', 'Mach')
-- 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')
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"
)
)
-- group by user_id
order by
-- count(*) desc,
rev_id -- , rev_user
-- limit 500
;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.