SELECT p.page_id, p.page_title, count(iwl.iwl_prefix) as iwlcount, concat("https://tr.wikipedia.org/w/index.php?action=edit&title=",p.page_title) as url

FROM page p join iwlinks iwl on iwl.iwl_from = p.page_id 

#join recentchanges rc on rc.rc_cur_id = p.page_id

where p.page_namespace = 0 and p.page_id not in 

(SELECT pp.page_id from page pp join iwlinks iwtr on iwtr.iwl_from = pp.page_id where pp.page_namespace= 0 and iwtr.iwl_prefix = "tr" )

​

group by 1 order by 3 desc;