Home

Wikimap

Terminology

• T0 - The target page_id
• T1 - The page_id of any page connected to T0
• T2 - The page_id of any page connected to T1

SQL Scripts

Refer to these links for full instructions on each SQL script:

1. Master SQL.sql
2. Page Connections Count.sql

Database Tables

page_connections

This table contains all of the connections for each page_id.

A page connection is:

1. Any page the article links to
2. Any page that links to the article