Todos los links hacia y desde algun articulo (eswiki)

Fork of Todos los links hacia y desde "Estallido social" (eswiki) by Diego (WMF)

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

We want to test this query so we can do it iteratively.

For now we are going to use an article with a few links for the time being.

SQL

SELECT
	page.page_title as page_from, pl.pl_title as page_to
FROM
  pagelinks pl
  LEFT JOIN page
    ON pl.pl_from = page.page_id
	
WHERE pl_title IN
		(
        SELECT
            page.page_title
        FROM
          pagelinks pl
          LEFT JOIN page
            ON pl.pl_from = page.page_id
          
        WHERE pl_title = 'Telmatobufo_australis'
)

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...