Untitled query #16174

SQL

USE trwiki_p;
SELECT CONCAT('[[',trpage.page_title,']]') AS page_title, CONCAT('[[User:',rev_user_text,']]') AS user,CONCAT('[[:en:',enwiki_p.page.page_title,'|en]] [[:de:',dewiki_p.page.page_title,'|de]] [[:fr:',frwiki_p.page.page_title,'|fr]]') AS suggestions
FROM page AS trpage
JOIN enwiki_p.page
ON  trpage.page_title= enwiki_p.page.page_title
JOIN dewiki_p.page
ON  trpage.page_title= dewiki_p.page.page_title
JOIN frwiki_p.page
ON  trpage.page_title= frwiki_p.page.page_title
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 enwiki_p.page.page_namespace = 0
AND enwiki_p.page.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)
OR trpage.page_title=enwiki_p.page.page_title
GROUP BY trpage.page_title;
SQL

Checking query status...
