SQL
x
use trwiki_p;
select *
from (select concat("http://tr.wikipedia.org/wiki?curid=",rev.rev_page) as url
, u.user_id as id, u.user_name as ad, u.user_editcount as ec
, rev.rev_id as revid, rev.rev_page as pid,rev.rev_deleted as rev_deleted,rev.rev_len as rev_len
, p.page_title as sayfa,p.page_is_new as yeni, p.page_touched as touched, p.page_latest as sonver, p.page_len as uzunluk
from user u join revision_userindex rev on rev.rev_user=u.user_id
left join page p on p.page_id = rev.rev_page
where u.user_name in ('Mirada')
and rev.rev_parent_id = 0
and
-- (p.page_id is null OR
(p.page_namespace = 0 and p.page_is_redirect = 0
-- and p.page_title rlike 'Aspar'
-- )
)
order by rev_len desc ) as p0
/*join revision_userindex r on r.rev_page = p0.pid
join user u2 on u2.user_id = r.rev_user
where r.rev_user>0
and u2.user_editcount > 1000
-- group by r.rev_user, p0.pid
limit 10
-- */
;
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.
Query status: complete
Executed on Sun, 02 Apr 2017 14:46:04 UTC.