Untitled query #9240

SQL

SELECT CONCAT('[[',enwikiquote_p.page.page_title,']]') AS enwikiquote, CONCAT('[[',enwiki_p.page.page_title,']]') AS enwiki
FROM enwiki_p.page
JOIN enwikiquote_p.page
ON enwiki_p.page.page_title = enwikiquote_p.page.page_title
LEFT JOIN enwikiquote_p.langlinks
ON ll_from = enwikiquote_p.page.page_id
LEFT JOIN (SELECT * FROM enwikiquote_p.page_props WHERE pp_propname = 'wikibase_item') AS props
ON pp_page = enwikiquote_p.page.page_id
LEFT JOIN enwikiquote_p.templatelinks
ON tl_from = enwikiquote_p.page.page_id
WHERE enwikiquote_p.page.page_namespace = 0
AND enwikiquote_p.page.page_is_redirect = 0
AND enwiki_p.page.page_namespace = 0
AND enwiki_p.page.page_is_redirect = 0
AND ll_title IS NULL
AND pp_value IS NULL
AND NOT EXISTS
(SELECT * FROM enwikiquote_p.templatelinks AS tl1
WHERE enwikiquote_p.page.page_id = tl1.tl_from
AND enwikiquote_p.page.page_namespace = tl1.tl_from_namespace
AND tl_namespace = 10
AND tl_title LIKE 'Disambiguation')
AND NOT EXISTS
(SELECT * FROM enwiki_p.templatelinks AS tl1
WHERE enwiki_p.page.page_id = tl1.tl_from
AND enwiki_p.page.page_namespace = tl1.tl_from_namespace
AND tl_namespace = 10
AND tl_title LIKE 'Disambiguation')
GROUP BY enwiki_p.page.page_title, enwikiquote_p.page.page_title;
SQL

Checking query status...
