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