trwiki:Articles not connected to Wikidata in Vikiproje Bilim Tarihi

SQL

USE trwiki_p;
SELECT DISTINCT article.page_id, article.page_title,article.page_len
FROM page talk
INNER JOIN page article ON
  talk.page_title = article.page_title
INNER JOIN categorylinks ON
  cl_from = talk.page_id
left join langlinks on ll_from = article.page_id AND ll_lang is null

/*LEFT JOIN (SELECT * FROM page_props 
                      WHERE pp_propname = 'wikibase_item') AS props
           ON pp_page = article.page_id */
WHERE
  talk.page_namespace = 1 AND
  article.page_namespace = 0 AND
  cl_to LIKE "Vikiproje_Bilim_tarihi%" AND
  /*pp_value IS NULL AND */
/*  article.page_id IN (SELECT pp_page FROM page_props 
      WHERE pp_propname = 'wikibase_item' AND pp_value IS NULL) AND*/
  article.page_is_redirect!=1;
  
/*SELECT pp_page FROM page_props 
      WHERE pp_propname = 'wikibase_item' AND pp_value IS NULL LIMIT 1;*/

SQL

Checking query status...