Evo or Revo?

<?php
$where ="createdby='".$modx->documentObject['createdby']."' AND isfolder='1' AND parent!='0' AND published='1'";
$result = $modx->db->makeArray($modx->db->select("id,pagetitle",$modx->getFullTableName('site_content'),$where,''));

if( $result ){
    $output ='The author of this article has written articles in the following categories: ';
    for( $x=0; $x<count($result); $x++ ) {
        $output .= '<a href="[~'.$result[$x]['id'].'~]">'.$result[$x]['pagetitle'].'</a>'.($x < count($result)-1 ? ', ' : '');
    }
    return $output;
}
?>

$c = $modx->newQuery('modResource');
$c->where(array(
    'createdby' => $modx->resource->get('createdby'),
    'isfolder' => true,
    'parent:!=' => 0,
    'published' => true,
));
$c->select(array('id','pagetitle'));
$resources = $modx->getCollection('modResource',$c);
$o = '';
if (!empty($resources)) {
  $o = array();
  foreach ($resources as $resource) {
     $o[] = '<a href="'.$modx->makeUrl($resource->get('id')).'">'.$resource->get('pagetitle').'</a>'."\n";
  }
  $o = 'The author of this article has written articles in the following categories: '.implode(',',$o);
}
return $o;

<?php
$c = $modx->newQuery('modResource');
$c->select('modResource.*, Parent.pagetitle as category');
$c->where(array('Parent.parent != 0', 'CreatedResources.createdby ' => $modx->resource->get('createdby')));
$c->groupBy('Parent.pagetitle');
/* Check the query output */
$c->bindGraph('{"CreatedResources":{"Parent":{}}}');
$c->prepare();
echo $c->toSQL();