no wikidata item

SQL

USE trwiki_p;

SELECT count(*) as kutusulumaddesayisi from (SELECT distinct page_id from page join templatelinks on tl_from = page_id where tl_title rlike "kutusu" 
and page_namespace = 0 and page_is_redirect = 0 and page_len > 100) as aaa ;

SELECT concat("[[",replace(p.page_title,"_"," "),"]]") as ad
, concat("http://tr.wikipedia.org/wiki?curid=",p.page_id) as url, p.page_latest, p.page_len
,tl_title, tl_namespace
from page p join templatelinks on tl_from = p.page_id
where p.page_namespace = 0 and p.page_is_redirect = 0 
and p.page_len > 100 -- byte
and tl_title rlike "kutusu"
-- and tl_title rlike "kişi"
-- and wp.page_title rlike p.page_title

and p.page_id not in (select ppp.pp_page FROM page_props ppp where ppp.pp_propname rlike "wikibase"
/*
and pp.pp_propname not rlike "image"
and pp.pp_propname not rlike "sort"
and pp.pp_propname not rlike "ambig"
and pp.pp_propname not rlike "title"
and pp.pp_propname not rlike "index"
and pp.pp_propname not rlike "newsect"
*/
)                   
group by p.page_id
order by tl_title, p.page_latest

;
SQL

Checking query status...
