Manual:Pagelinks table

Contains for each internal link from a current page the id of the source page, the target namespace number, and the target page title without namespace.

The target page may or may not exist, and due to renames and deletions may refer to different page records as time goes by.

The table is new to version 1.5. It is the result of merging the links table and the brokenlinks table of version 1.4.

DESCRIBE pagelinks;

+--+-+--+-+-+---+ +--+-+--+-+-+---+ +--+-+--+-+-+---+
 * Field       | Type            | Null | Key | Default | Extra |
 * pl_from     | int(8) unsigned | NO   | PRI | 0       |       |
 * pl_namespace | int(11)        | NO   | PRI | 0       |       |
 * pl_title    | varchar(255)    | NO   | PRI |         |       |

mysql> describe mw_pagelinks; +--+-+--+-+-+---+ +--+-+--+-+-+---+ +--+-+--+-+-+---+
 * Field       | Type            | Null | Key | Default | Extra |
 * pl_from     | int(8) unsigned | NO   | PRI | 0       |       |
 * pl_namespace | int(11)        | NO   | PRI | 0       |       |
 * pl_title    | varchar(255)    | NO   | PRI | NULL    |       |

mysql> describe mw_pagelinks; +--+--+--+-+-+---+ +--+--+--+-+-+---+ +--+--+--+-+-+---+
 * Field       | Type             | Null | Key | Default | Extra |
 * pl_from     | int(10) unsigned | NO   | PRI | 0       |       |
 * pl_namespace | int(11)         | NO   | PRI | 0       |       |
 * pl_title    | varchar(255)     | NO   | PRI |         |       |