Skip to content

Instantly share code, notes, and snippets.

@milimetric

milimetric/categoryEdgeList.sql

Last active December 25, 2015 07:09
Show Gist options
  • Save milimetric/6937689 to your computer and use it in GitHub Desktop.
Save milimetric/6937689 to your computer and use it in GitHub Desktop.
Download ZIP
Category Edge List for MediaWiki content
Raw
categoryEdgeList.sql
select p1.page_title as child_title
,p1.page_id as child_id
,p2.page_title as parent_title
,p2.page_id as parent_id
from categorylinks cl
inner join
page p1 on p1.page_id = cl.cl_from
inner join
page p2 on p2.page_title = cl.cl_to
and p2.page_id <> cl.cl_from
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment