trwiki:Articles not connected to Wikidata but similar to ruwiki articles

SQL

SELECT CONCAT('[[',trwiki_p.page.page_title,']]') AS tr, coalesce(CONCAT('[[:ru:',ruwiki_p.page.page_title,'|',ruwiki_p.page.page_title,']]'),ruwiki_p.page.page_title) AS ru
FROM ruwiki_p.page
JOIN trwiki_p.page
ON ruwiki_p.page.page_title = trwiki_p.page.page_title
LEFT JOIN (SELECT * FROM trwiki_p.page_props WHERE pp_propname = 'wikibase_item') AS props
ON pp_page = trwiki_p.page.page_id
WHERE trwiki_p.page.page_namespace = 0
AND trwiki_p.page.page_is_redirect = 0
AND ruwiki_p.page.page_namespace = 0
AND ruwiki_p.page.page_is_redirect = 0
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)
AND NOT EXISTS
(SELECT * FROM ruwiki_p.page_props AS disambig2
WHERE disambig2.pp_propname LIKE 'disambiguation'
AND disambig2.pp_page = ruwiki_p.page.page_id)
GROUP BY ruwiki_p.page.page_title, trwiki_p.page.page_title;
SQL

Checking query status...
