Sans titre

SELECT (SUM(rank)::float / COUNT(id)::float)::float,		_count.nb_blogs,	   (4 * _count.nb_blogs + 100 * _count.nb_blogs*_count.nb_blogs)/(100 * (1 + 2 * _count.nb_blogs + _count.nb_blogs*_count.nb_blogs))FROM _top_blog,	(			SELECT COUNT(DISTINCT(_blog.id))::float AS nb_blogs		FROM   _relation		JOIN   _blog				ON _blog.id = _relation.destination_id		WHERE _relation.path <@ '0.1.40215'	) AS _countWHERE id IN (	SELECT DISTINCT(_blog.id)	FROM   _relation	JOIN   _blog		ON _blog.id = _relation.destination_id	JOIN   _article		ON _article.path <@ _blog.path	WHERE _relation.path <@ '0.1.40215'	AND    extract (day FROM (localtimestamp - _article.date_publishing))::int < 30	)GROUP BY _count.nb_blogs;