ex recherche dans une table

gistfile1.txt

$criteria = $modx->newQuery('modResource');  
$criteria->leftJoin('modUser','PublishedBy');  
$criteria->where(array(  
    'modResource.published' => 1,  
    'modResource.searchable' => 1,
  'pagetitle:LIKE' => $value.'%'

));  
$criteria->orCondition(array(  
    'PublishedBy.username' => 'george123',  
),null,1);  
$criteria->sortby('menuindex','ASC');  
$criteria->limit(10,20);  

$Total = $modx->getCount('modResource',$criteria);
$resources = $modx->getCollection('modResource',$criteria);