USE enwiki_p;

SET @NS = 0 ;

​

select p.page_id as id, concat("[[",p.page_title,"]]") as madde, count(*) as llsayi

, concat("https://en.wikipedia.org/wiki?curid=",p.page_id) as url_ms

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

​

where p.page_namespace = @NS 

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" )

group by 1 having count(*)>100

order by 3 desc

​

limit 500

;