public function getUserById($id, $loggedUserId)
{
$db = JFactory::getDbo();
$query = "SELECT u.*, su.provider, COUNT(DISTINCT fd.id) followers, COUNT(DISTINCT fr.id) following, f.id followed " . "FROM text_users u " . "LEFT JOIN text_follows fd ON (u.id=fd.followed_id) " . "LEFT JOIN text_follows fr ON (u.id=fr.follower_id) " . "LEFT JOIN text_follows f ON ((u.id=f.followed_id) AND (f.follower_id = " . $loggedUserId . ")) " . "LEFT JOIN text_slogin_users su ON (u.id=su.user_id) " . "WHERE u.id=" . $id . " group by u.id";
$db->setQuery($query);
$user_info = $db->loadObject();
$user_info->following = Ideary::getCountUsersWhoIAmFollowing($id);
$user_info->followers = Ideary::getCountUsersWhoFollowMe($id);
$user_info->applausses_received = Ideary::getCountApplaussesByUserId($id);
return $user_info;
}
