pdotools + tvsuperselect

{$_modx->runSnippet('pdoPage', [
	'element' => 'tvssResources',
	'tv' => '7',
	'tags' => $_modx->runSnippet('pdoResources' , [ 
		'loadModels' => 'tvsuperselect','class' => 'tvssOption',
		'sortby' => '{ "value":"ASC" }'
		'groupby' => 'value',	'tpl' => '@INLINE {$value}', 'tplWrapper' => '@INLINE {$output}',
		'limit'=>0,'outputSeparator'=>'||'
		]),
	'parents' => 10,  'limit' => 0,
	'tpl' => '@INLINE <div>{$pagetitle}{$tags}</div>',
    ])}

{'pdoResources' | snippet : [ 'parents' => 10, 'limit' => 0,
'groupby' => 'val', 'sortby'=> 'val', 'sortdir' => 'ASC',
'select' => '{"modResource":"id,pagetitle","tvss":"count(value) as cnt, value as val"}',
'innerJoin'=>'{ "tvss": {"class":"tvssOption","alias":"tvss","on":"tvss.resource_id=modResource.id"}}',
'tpl'=> '@INLINE {$val} ({$cnt}) <p>{$pagetitle}</p>', 
 'showLog'=> 1
]}

0.0001180: pdoTools loaded
0.0000310: xPDO query object created
0.0005209: innerJoined tvssOption as tvss
0.0000041: Grouped by val
0.0001049: Added selection of modResource: SQL_CALC_FOUND_ROWS `id`, `pagetitle`
0.0000241: Added selection of tvssOption: count(value) as cnt, value as val
0.0017450: Processed additional conditions
0.0020249: Added where condition: modResource.parent:IN(10,14,15,18,25,30,19,26,24,16,17), modResource.published=1, modResource.deleted=0
0.0000939: Sorted by val, ASC
0.0013371: SQL prepared "SELECT SQL_CALC_FOUND_ROWS `modResource`.`id`, `modResource`.`pagetitle`, count(value) as cnt, value as val FROM `modx_site_content` AS `modResource` JOIN `modx_tvss_options` `tvss` ON tvss.resource_id=modResource.id WHERE  ( `modResource`.`parent` IN (10,14,15,18,25,30,19,26,24,16,17) AND `modResource`.`published` = 1 AND `modResource`.`deleted` = 0 )  GROUP BY val ORDER BY val ASC "
0.0014529: SQL executed
0.0001609: Total rows: 5
0.0000231: Rows fetched
0.0002599: Created inline "modChunk" with name "1530b8d8924dfc8cb34a1caeaa0cf9b0"
0.0185289: Compiled Fenom chunk with name "modchunk/1530b8d8924dfc8cb34a1caeaa0cf9b0"
0.0190470: Returning processed chunks
0.0251350: Total time
6 291 456: Memory usage

{'pdoResources' | snippet : [ 'parents' => 10, 'limit' => 0,
'groupby' => 'val', 'sortby'=> 'val', 'sortdir' => 'ASC',
'select' => '{"modResource":"id,pagetitle","tvss":"count(value) as cnt, value as val, (select GROUP_CONCAT(resource_id) as t from modx_tvss_options where value = val) as idv " }',
'innerJoin'=>'[{"class":"tvssOption","alias":"tvss","on":"tvss.resource_id=modResource.id"}]',
'tpl'=> '@INLINE {$val} ({$cnt}) <p>
{set $ar = $idv |split}
{foreach $ar as $row}
[[#{$row}.pagetitle]]
{/foreach}
</p>', 
 'showLog'=> 1,
 'return' => 'null'
]}