This query is marked as a draft This query has been published by XXN.

SQL

AخA
 
USE wikidatawiki_p;
SELECT CONCAT("# [[Q",epp1.epp_entity_id,"]]") AS item, GROUP_CONCAT(DISTINCT CONCAT("[[",further_links.pl_title,"]]") SEPARATOR ', ') AS links_to,
    GROUP_CONCAT(DISTINCT CONCAT("Q",backlinks.epp_entity_id) SEPARATOR ', ') AS backlinks
    FROM (SELECT * FROM pagelinks WHERE pl_title = "Q11266439" AND pl_from_namespace = 0) AS dupes#Q4167836
    JOIN wb_entity_per_page AS epp1
        ON epp_page_id = dupes.pl_from
    LEFT JOIN wb_items_per_site
        ON ips_item_id = epp_entity_id
    LEFT JOIN (SELECT * FROM pagelinks WHERE pl_from_namespace = 0 AND pl_namespace = 0) AS further_links
        ON further_links.pl_from = dupes.pl_from /*AND further_links.pl_title <> "Q17362920"*/
    LEFT JOIN (SELECT * FROM pagelinks
                JOIN wb_entity_per_page ON epp_page_id = pl_from
                WHERE pl_namespace = 0) AS backlinks
        ON backlinks.pl_title = CONCAT("Q",epp1.epp_entity_id)
WHERE ips_item_id IS NULL
GROUP BY dupes.pl_from
    having COUNT(DISTINCT backlinks.pl_from) = 0
#ORDER BY COUNT(DISTINCT backlinks.pl_from) DESC, dupes.pl_from;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...