Index: trunk/kernel/units/users/users_config.php =================================================================== diff -u -r3907 -r4029 --- trunk/kernel/units/users/users_config.php (.../users_config.php) (revision 3907) +++ trunk/kernel/units/users/users_config.php (.../users_config.php) (revision 4029) @@ -50,10 +50,14 @@ 'ItemType' => 6, // used for custom fields only (on user's case) 'TableName' => TABLE_PREFIX.'PortalUser', - 'ListSQLs' => Array( ''=>'SELECT * FROM %s', - ), // key - special, value - list select sql - 'ItemSQLs' => Array( ''=>'SELECT * FROM %s', - ), + 'ListSQLs' => Array( '' => ' SELECT %1$s.* %2$s FROM %1$s + LEFT JOIN '.TABLE_PREFIX.'%3$sPortalUserCustomData cust ON %1$s.ResourceId = cust.ResourceId', + ), + + 'ItemSQLs' => Array( '' => ' SELECT %1$s.* %2$s FROM %1$s + LEFT JOIN '.TABLE_PREFIX.'%3$sPortalUserCustomData cust ON %1$s.ResourceId = cust.ResourceId', + ), + 'ListSortings' => Array( '' => Array( 'Sorting' => Array('Login' => 'asc'),