trwiki:Categories not connected to Wikidata items

SQL

USE trwiki_p;
SELECT CONCAT('[[Kategori:',page_title,']]') AS page_title, DATE_FORMAT(rev_timestamp,"%Y-%m-%d") AS rev_timestamp, CONCAT('[[User:',rev_actor,']]') AS rev_user_text
FROM page
LEFT JOIN langlinks
ON ll_from = page_id
LEFT JOIN (SELECT * FROM page_props WHERE pp_propname = 'wikibase_item') AS props
ON pp_page = page_id
LEFT JOIN revision
ON rev_page = page_id
LEFT JOIN templatelinks
ON tl_from = page_id
WHERE page_namespace = 14
AND page_is_redirect = 0
AND rev_parent_id = 0
AND ll_title IS NULL
AND pp_value IS NULL
AND NOT EXISTS
(SELECT * FROM trwiki_p.page_props AS disambig1
WHERE disambig1.pp_propname LIKE 'disambiguation'
AND disambig1.pp_page = trwiki_p.page.page_id)
GROUP BY page_title
ORDER BY rev_timestamp DESC, page_title ASC;
SQL

Checking query status...
