USE dewiki_p;

SELECT NOW();

SET @LANG = "de";

SET @NS = 14 ;

SET @NSad = "Kategori";

SELECT  p.page_id, p.page_title, count(*) as llsayi

, concat("tr.wikipedia.org/w/index.php?action=edit&title=",@NSad,":",p.page_title) as urltr

, concat(@LANG,".wikipedia.org/wiki?action=edit&curid=",p.page_id) as url

FROM page p join langlinks ll on ll.ll_from = p.page_id 

-- left join trwiki_p.page trp on trp.page_title = p.page_title

join recentchanges rc on rc.rc_cur_id = p.page_id

where p.page_namespace = @NS 

-- and p.page_title not like "List%" 

and p.page_id not in 

(SELECT DISTINCT(pp.page_id) from page pp join langlinks ltr on ltr.ll_from = pp.page_id where 

 pp.page_namespace = @NS 

 and ltr.ll_lang = "tr" )

-- and trp.page_namespace = @NS 

​

group by 1 order by 3 desc

-- LIMIT 100

;

SELECT NOW();