This query is marked as a draft This query has been published by Bulgu.

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.

Checking query status...