Portals which also link to a portal's articles

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

Change the WHERE line to choose the relevant portal, using underscores rather than spaces and omitting Portal:  Example:
WHERE page_namespace=100 AND page_title="A._H._Belo"

SQL

SET STATEMENT max_statement_time=1000 FOR
SELECT PL1.pl_title article, MIN(page_title) other_portal_1, MAX(page_title) other_portal_2, COUNT(*) portal_count
FROM pagelinks PL1
JOIN pagelinks PL2 ON PL2.pl_title=PL1.pl_title  AND PL2.pl_from_namespace=100 AND PL2.pl_namespace=0
JOIN page ON page_id=PL2.pl_from
WHERE PL1.pl_from=59772475 /* <=== Change this to the page_id of the portal of interest */
AND PL1.pl_from_namespace=100 AND PL1.pl_namespace=0
GROUP BY PL1.pl_title
LIMIT 100;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...