‎ - Quarry

Fork of Links from a page with page size by BDavis (WMF)

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

Use the pagelinks table to find all outbound links on a page (Main_Page in this example) along with the size of the current revision of each linked page.

SQL

SELECT
  p.page_title,
  pl.pl_title,
  r.rev_len
FROM
  page AS p
  LEFT JOIN pagelinks AS pl ON (pl.pl_from = p.page_id)
  LEFT OUTER JOIN page AS lp ON (lp.page_title = pl.pl_title)
  LEFT OUTER JOIN revision AS r ON (r.rev_id = lp.page_latest)
WHERE
  p.page_title='Main_Page'
  AND p.page_namespace=0
;

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