gistfile1.php

<?php

function process() 
{ 
    // Custom SQL 
    $lvsParams = array( 
        'custom_select' => ',calls.id AS call_id', 
        'custom_from' => ' LEFT JOIN calls ON calls.parent_id = accounts.id', 
        'custom_where' => ' AND (calls.id IS NULL)', 
        'distinct' => true 
    ); 
     
    // Newest accounts are listed at top 
    $lvsParams['overrideOrder'] = true;  
    $lvsParams['orderBy'] = 'date_entered';  
    $lvsParams['sortOrder'] = 'DESC'; 
     
    parent::process($lvsParams); 
     
}