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 (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

SQL

Checking query status...