Semantic MediaWiki/data/smw subs2

About

 * Version: 1.7
 * Documentation status: unofficial; confirmed only by testing
 * Purpose: seems to be a mapping of categories and sub-categories

SQL
CREATE TABLE `smw_subs2` ( `s_id` int(8) unsigned NOT NULL,  `o_id` int(8) unsigned DEFAULT NULL,  KEY `s_id` (`s_id`),  KEY `o_id` (`o_id`) ) ENGINE=InnoDB DEFAULT CHARSET=binary;

Example
SELECT s_id, o_id , CAST(s.smw_title AS char) AS s_title , CAST(o.smw_title AS char) AS o_title FROM (smw_subs2 AS x   LEFT JOIN smw_ids AS s ON x.s_id=s.smw_id) LEFT JOIN smw_ids AS o ON x.o_id=o.smw_id;