trwikt(modül)

SQL

USE enwiktionary_p;
SELECT NOW();
SET @LANG = "en";
SET @NS = 828 ; -- 828 (modül) 10 (şablon) 
SET @NSad = "Şablon";  -- Modül Şablon  
SET @ekle = "action=edit&";
SET @ekle2 ="";
SELECT  p.page_id, p.page_title, count(*) as llsayi
, concat("tr.wiktionary.org/w/index.php?action=edit&title=",@NSad,":",p.page_title) as urltr
, concat(@LANG,".wiktionary.org/wiki?",@ekle2,"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();
SQL

Checking query status...
