Semantic MediaWiki/data/smw di wikipage

About

 * Purpose: specifications for all SMW Objects that point to wiki pages (existing or not)
 * Refers to:

SQL
delimiter $$

CREATE TABLE `smw_di_wikipage` ( `s_id` int(8) unsigned NOT NULL,  `p_id` int(8) unsigned NOT NULL,  `o_id` int(8) unsigned DEFAULT NULL,  KEY `s_id` (`s_id`,`p_id`),  KEY `p_id` (`p_id`,`o_id`),  KEY `o_id` (`o_id`) ) ENGINE=InnoDB DEFAULT CHARSET=binary$$

Example
SELECT s_id , s.smw_namespace AS s_namespace , CAST(s.smw_title AS char) AS s_title , p.smw_namespace AS p_namespace , CAST(p.smw_title AS char) AS p_title , o.smw_namespace AS o_namespace , CAST(o.smw_title AS char) AS o_title FROM ((smw_di_wikipage AS r   LEFT JOIN smw_object_ids AS s ON r.s_id=s.smw_id)    LEFT JOIN smw_object_ids AS p ON r.p_id=p.smw_id) LEFT JOIN smw_object_ids AS o ON r.o_id=o.smw_id ORDER BY s_id,p_title, o_title
 * p_namespace will probably always be the "property:" namespace, which defaults to 102 (unless there's some way to use a page outside that namespace as a property)