SELECT 				
	_article.id, 
	_article.parent_id, 
	_article.path, 
	_article.data, 
	_article.date_creation, 
	_article.date_publishing, 
	_article.date_modification, 
	_article.reference, 
	_article.title, _article.text, (localtimestamp - _article.date_publishing) , 
	_topic.name as topic_name, 
	_topic.id AS topic_id, 
	_topic.reference AS topic_reference, 
	(	
		SELECT COUNT (id) 
		FROM _comment 
		WHERE parent_id = _article.id
	) AS nb_comments
FROM   _article 

		LEFT JOIN _topic
			ON _article.parent_id = _topic.id 

WHERE  
	_article.id IN
		(
			SELECT _article.id
			FROM _article
			
		LEFT JOIN _topic
			ON _article.parent_id = _topic.id 
			
			
			WHERE  _article.path <@ '0.1.1225584'
			
			AND _article.date_publishing <= '2007-11-21T11:14:17+01:00' 
			GROUP BY _article.id , _article.date_publishing 
			ORDER BY 
			(localtimestamp - _article.date_publishing) ASC
			OFFSET 0
			LIMIT 40						
		)

AND _article.date_publishing <= '2007-11-21T11:14:17+01:00' 
GROUP BY 
	_article.id, 
	_article.parent_id, 
	_article.path, 
	_article.data, 
	_article.date_creation, 
	_article.date_publishing, 
	_article.date_modification, 
	_article.reference, 
	_article.title,
	_article.text, _topic.name, _topic.id, _topic.reference
ORDER BY (localtimestamp - _article.date_publishing) ASC
OFFSET 0 
LIMIT 40