no wikidata item

SQL

USE trwiki_p;
select now();
SELECT p.page_id as id, p.page_title as ad, concat("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
-- left join wikidatawiki_p.page wp on wp.page_title = p.page_title
-- join page_props pp on pp.pp_page = 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 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"
*/
and p.page_id not in (select ppp.pp_page
FROM page_props ppp
where ppp.pp_propname rlike "wikibase"
) 
group by p.page_id
order by tl_title, p.page_latest
-- limit 10
;
select now();
SQL

Checking query status...
