site_tmplvar_contentvalues

CREATE TABLE IF NOT EXISTS `{PREFIX}site_tmplvar_contentvalues` (
   `id` int(11) NOT NULL auto_increment,
   `tmplvarid` int(10) NOT NULL default '0' COMMENT 'Template Variable id',
   `contentid` int(10) NOT NULL default '0' COMMENT 'Site Content Id',
   `value` mediumtext,
   PRIMARY KEY (id),
   KEY idx_tmplvarid (tmplvarid),
   KEY idx_id (contentid),
   FULLTEXT KEY `value_ft_idx` (`value`)
) ENGINE=MyISAM COMMENT='Site Template Variables Content Values Link Table';

SELECT tvv.contentid AS docid,IF(tvv.value!='',tvv.value,tv.default_text) as value,tv.name,tv.id
FROM modx_site_tmplvar_contentvalues tvv LEFT JOIN modx_site_tmplvars tv ON tvv.tmplvarid=tv.id

http://grapee.jp/77738