Аватары пользователей в ленте активности

 $sql = "SELECT log.*,
		               log.pubdate as orig_pubdate,
                       a.message,
                       a.name,
                       u.nickname as user_nickname,
                       u.login as user_login
                FROM cms_actions_log log
                LEFT JOIN cms_actions a ON a.id = log.action_id AND a.is_visible = 1
                LEFT JOIN cms_users u ON u.id = log.user_id
                WHERE 1=1 {$this->inDB->where}
                ORDER BY log.id DESC
				";

 $sql = "SELECT log.*,
		               log.pubdate as orig_pubdate,
                       a.message,
                       a.name,
                       u.nickname as user_nickname,
                       u.login as user_login, u.is_deleted, p.imageurl
                FROM cms_actions_log log
                LEFT JOIN cms_actions a ON a.id = log.action_id AND a.is_visible = 1
                LEFT JOIN cms_users u ON u.id = log.user_id
				INNER JOIN cms_user_profiles p ON p.user_id = log.user_id
                WHERE 1=1 {$this->inDB->where}
                ORDER BY log.id DESC
				";

 $action['pubdate']  = cmsCore::dateDiffNow($action['pubdate']);

 
$action['user_avatar'] = cmsUser::getUserAvatarUrl($action['user_id'], 'small', $action['imageurl'], $action['is_deleted']);

{foreach key=aid item=action from=$actions}

{/foreach}

<img src="{$action.user_avatar}" class="action_usr_ava"/>