vikisöz'e bağlantı trwiki'de var ama vikiveri'de yok

SQL

USE trwiki_p;
select concat("[[",page_title,"|",replace(page_title,"_"," "),"]]") as ad
, concat("https://tr.wikipedia.org/wiki?curid=",page_id) as url
-- , page_latest as son_rev
, concat("[[d:",pp_value,"|]]") as wd
, left(rev_timestamp,8) as son_degisiklik_tarihi
, count(*)
from templatelinks 
join page on page_id = tl_from
left join page_props pp on pp.pp_page = page_id
left join revision_userindex on rev_id = page_latest
where page_namespace = 0
and tl_from_namespace = 0
and tl_namespace = 10
and tl_title in ("Vikisöz","Wikiquote") 
and (pp.pp_propname is NULL OR pp.pp_propname ="wikibase_item" ) 

and page_id not in (select pps.pp_page 
                    from page_props pps 
                    where pps.pp_propname ="wikibase_item" 
                    and pps.pp_value in
                       ( select concat("Q",ips.ips_item_id) as aa from wikidatawiki_p.wb_items_per_site ips
                        where ips.ips_site_id = "trwikiquote" 
                        )
                    )
group by page_id                   
order by page_latest
;
select now();
SQL

Checking query status...
