MediaWiki/tables

page_props

Stores "page properties". I'm not quite sure how this is supposed to be used, as it always seems to be empty until I start mucking around with it.

Names and values are kept in binary blobs, though (even though they are strings), so you have to do a modified query to see what's going on:

SELECT pp_page, CAST(pp_propname AS CHAR) AS Name, CAST(pp_value AS CHAR) AS Value, pp_sortkey FROM page_props;

A slightly more complex query to show the names of the pages (instead of just IDs):

SELECT 
    pp_page,
    page_namespace,
    page_title,
    CAST(pp_propname AS CHAR) AS Name,
    CAST(pp_value AS CHAR) AS Value,
    pp_sortkey
FROM
    page_props
        LEFT JOIN
    page ON pp_page = page_id