$where = $modx->newQuery('modResource');
$where->innerJoin('modTemplateVarResource','TemplateVarResources');
$where->innerJoin('modTemplateVar','TemplateVar','`TemplateVar`.`id` = `TemplateVarResources`.`tmplvarid`');
$where->where(array(
    'parent' => 2,
    'deletedby' => 0,
    'TemplateVar.name' => 'tvtest',
    'TemplateVarResources.value:like' => '%valuetest%'
));
$resources = $modx->getCollection('modResource',$where);