SELECT id, parent_id, reference, text, data, date_publishing
FROM  _comment
WHERE _comment.parent_id = '1001206797'
ORDER BY (localtimestamp - _comment.date_publishing) DESC
OFFSET 0
LIMIT  50 

SELECT id, parent_id, reference, text, data, date_publishing
FROM  _comment
WHERE _comment.parent_id = '1001206797'
ORDER BY _comment.date_publishing ASC
OFFSET 0
LIMIT  50