trwiki:Articles not connected to Wikidata items by author (with several language projects suggestions)

SQL

USE trwiki_p;
SET sql_mode='PIPES_AS_CONCAT';
SELECT CONCAT('[['||trpage.page_title||']]') AS page_title, CONCAT('[[User:'||rev_user_text||']]') AS user,
CONCAT(
  IF(trpage.page_title IN (SELECT enwiki_p.page.page_title FROM enwiki_p.page 
                           WHERE enwiki_p.page.page_namespace = 0 AND 
                           enwiki_p.page.page_is_redirect = 0),
                           '[[:en:'||trpage.page_title||'|en]]',NULL)||' '||
  IF(trpage.page_title IN (SELECT dewiki_p.page.page_title FROM dewiki_p.page 
                           WHERE dewiki_p.page.page_namespace = 0 AND 
                           dewiki_p.page.page_is_redirect = 0),
                           '[[:de:'||trpage.page_title||'|de]]',NULL)||' '||
  IF(trpage.page_title IN (SELECT frwiki_p.page.page_title FROM frwiki_p.page 
                           WHERE frwiki_p.page.page_namespace = 0 AND 
                           frwiki_p.page.page_is_redirect = 0),
                           '[[:fr:'||trpage.page_title||'|fr]]',NULL)||' '||
  IF(trpage.page_title IN (SELECT itwiki_p.page.page_title FROM itwiki_p.page 
                           WHERE itwiki_p.page.page_namespace = 0 AND 
                           itwiki_p.page.page_is_redirect = 0),
                           '[[:it:'||trpage.page_title||'|it]]',NULL)||' '||
  IF(trpage.page_title IN (SELECT eswiki_p.page.page_title FROM eswiki_p.page 
                           WHERE eswiki_p.page.page_namespace = 0 AND 
                           eswiki_p.page.page_is_redirect = 0),
                           '[[:es:'||trpage.page_title||'|es]]',NULL)||' '||
  IF(trpage.page_title IN (SELECT ruwiki_p.page.page_title
FROM ruwiki_p.page
JOIN trwiki_p.page
ON ruwiki_p.page.page_title = trwiki_p.page.page_title AND trwiki_p.page.page_namespace = 0
AND trwiki_p.page.page_is_redirect = 0
                           WHERE ruwiki_p.page.page_namespace = 0 AND 
                           ruwiki_p.page.page_is_redirect = 0),
                           '[[:ru:'||trpage.page_title||'|ru]]',NULL)  
  
  ) AS suggestions
FROM page AS trpage
/*JOIN enwiki_p.page
ON  trpage.page_title= enwiki_p.page.page_title
AND enwiki_p.page.page_namespace = 0
AND enwiki_p.page.page_is_redirect = 0
LEFT JOIN langlinks
ON ll_from = trpage.page_id*/
LEFT JOIN (SELECT * FROM page_props WHERE pp_propname = 'wikibase_item') AS props
ON pp_page = trpage.page_id
LEFT JOIN revision
ON rev_page = trpage.page_id
WHERE trpage.page_namespace = 0
AND trpage.page_is_redirect = 0
AND rev_parent_id = 0
/*AND ll_title IS NULL*/
AND pp_value IS NULL
AND NOT EXISTS
(SELECT * FROM page_props AS disambig1
WHERE disambig1.pp_propname LIKE 'disambiguation'
AND disambig1.pp_page = trpage.page_id)
GROUP BY trpage.page_title;
SQL

Checking query status...
