Something

function getRank($points){
		$memcache_key = __FUNCTION__ . __CLASS__ . "_{$this->userId}";

		if (!($ret = Cache::get($memcache_key))) {
			$query="SELECT COUNT( * ) +1 AS ranking
					FROM
					(
						(
							(
								(
									(
										(
											(
												(
													users U LEFT JOIN view_favorite favorite ON U.user_id = favorite.user_id
												)
												LEFT JOIN view_comment_score cs ON U.user_id = cs.user_id
											)
											LEFT JOIN view_profile_views pv ON U.user_id = pv.user_id
										)
										LEFT JOIN view_comments_own vcown ON U.user_id = vcown.user_id
									)
									LEFT JOIN view_uploadedpic vu ON U.user_id = vu.user_id
								)
								LEFT JOIN view_views_own vviewown ON U.user_id = vviewown.user_id
							)
							LEFT JOIN view_votes_other vvother ON U.user_id = vvother.user_id
						)
						LEFT JOIN view_votes_own vvoteown ON U.user_id = vvoteown.user_id
					)
					LEFT JOIN view_group_score gs ON U.user_id = gs.user_id
					WHERE(
						( COALESCE( pv.totalviews, 0 ) *".$points['profileview']." ) + 
						( COALESCE( cs.score, 0 ) *".$points['commentscore']." ) + 
						( COALESCE( vcown.totalcomments, 0 ) *".$points['pointCommentOwn']." ) + 
						( COALESCE( vu.totaluploadedpic, 0 ) *".$points['uploadedPicture']." ) + 
						( COALESCE( vviewown.totalviews, 0 ) *".$points['viewOwn']." ) + 
						( COALESCE( favorite.totalfavorite, 0 ) *".$points['favorite']." ) + 
						( COALESCE( vvother.totalvotes, 0 ) *".$points['voteOther']." ) + 
						( COALESCE( vvoteown.totalvotes, 0 ) *".$points['voteOwn']." ) +
						COALESCE( gs.totalpoints, 0 )
					) > (
						SELECT (
							( COALESCE( pv.totalviews, 0 ) *".$points['profileview']." ) + 
							( COALESCE( cs.score, 0 ) *".$points['commentscore']." ) + 
							( COALESCE( vcown.totalcomments, 0 ) *".$points['pointCommentOwn']." ) + 
							( COALESCE( vu.totaluploadedpic, 0 ) *".$points['uploadedPicture']." ) + 
							( COALESCE( vviewown.totalviews, 0 ) *".$points['viewOwn']." ) +
							( COALESCE( favorite.totalfavorite, 0 ) *".$points['favorite']." ) +  
							( COALESCE( vvother.totalvotes, 0 ) *".$points['voteOther']." ) + 
							( COALESCE( vvoteown.totalvotes, 0 ) *".$points['voteOwn']." ) +
							COALESCE( gs.totalpoints, 0 )
						) FROM (
					(
					(
					(
					(
					(
					(
					(
					users U
					LEFT JOIN view_favorite favorite ON U.user_id = favorite.user_id
					)
					LEFT JOIN view_comment_score cs ON U.user_id = cs.user_id
					)
					LEFT JOIN view_profile_views pv ON U.user_id = pv.user_id
					)
					LEFT JOIN view_comments_own vcown ON U.user_id = vcown.user_id
					)
					LEFT JOIN view_uploadedpic vu ON U.user_id = vu.user_id
					)
					LEFT JOIN view_views_own vviewown ON U.user_id = vviewown.user_id
					)
					LEFT JOIN view_votes_other vvother ON U.user_id = vvother.user_id
					)
					LEFT JOIN view_votes_own vvoteown ON U.user_id = vvoteown.user_id
					)
					LEFT JOIN view_group_score gs ON U.user_id = gs.user_id
					WHERE U.user_id =".$this->userId."
					)";
			$result = mysql_query($query);
			$row = mysql_fetch_row($result);
			$ret = $row[0];
			Cache::set($memcache_key, $ret);
		}
		return $ret;
	}