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.