diğer wikilerin çoğunda olup trwiki'de olmayan sayfalar

SQL

SELECT NOW();
SELECT p.page_id, p.page_title, count(*) as llcount, concat("https://tr.wikipedia.org/w/index.php?action=edit&title=",p.page_title) as url
FROM page p join langlinks ll on ll.ll_from = p.page_id 
#join recentchanges rc on rc.rc_cur_id = p.page_id
where p.page_namespace = 0 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= 0 and ltr.ll_lang = "tr" )

group by 1 order by 3 desc
LIMIT 100;
SELECT NOW();

SQL

Checking query status...