use trwiki_p;

SET @uid = 174948;

​

select page_title, concat("tr.wikipedia.org/wiki?curid=",rev.rev_page) as url

, concat("https://tr.wikipedia.org/wiki?oldid=",max(fr_rev_id)) as urlrev 

-- , (page_latest - max(fr_rev_id)) as sifirmi

, page_is_redirect, page_namespace

from revision_userindex rev

join flaggedrevs on fr_page_id = rev.rev_page

join page on page_id =rev.rev_page

​

where 

-- rev.rev_user = @uid and 

rev.rev_parent_id = 0

and page_namespace = 0

and fr_page_id not in (select fp_page_id from flaggedpages)

group by rev.rev_page

order by 4 desc, 3 asc

;

​

​

/*

​

select *

from (select concat("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_len as rev_len

, replace(p.page_title,"_"," ") as sayfa,p.page_is_new as yeni, p.page_latest as sonversiyon, 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_namespace = 0 and p.page_is_redirect = 0 

--     and p.page_title rlike 'Aspar'

      )

     --  OR p.page_id is null 

     )

order by rev_len desc, sonversiyon asc ) 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 

-- */

;