Как изменить запрос к БД чтоб получить не Имя, а ID пользователя? - JoomlaCK

		if(defined('_JEXEC'))
		{   
			$sql =  'select usr.username from #__session ips '
			. 'join #__session uip on uip.session_id = ips.data '
			. 'join #__users usr on usr.id = uip.userid '
			. 'where ips.session_id  = "' .$ip_recorded_for_jusr . '"';
			
			
        }
		else
		{
				
			$sql = 'select usr.username from #__session ips '
			. 'join #__session uip on uip.session_id = ips.username '
			. 'join #__users usr on usr.id = uip.userid '
			. 'where ips.session_id  = "' .$ip_recorded_for_jusr . '"';
		} 
	
		$database->setQuery( $sql );
		$user = $database->loadResult();

usr.id