select
distinct on (article_id)
ticket.tn	           AS "ID заявки",
s1.a_body            AS "Описание",
article_id

FROM
ticket
RIGHT JOIN article ON ticket.id = article.ticket_id 
INNER JOIN article_data_mime as s1 ON s1.article_id = article.id
where /*s1.article_id = (SELECT MIN(article_id) FROM article_data_mime s2 where s2.id = s1.id)*/  
and  s1.create_time = ticket.create_time
GROUP BY
ticket.tn,
s1.article_id,
s1.a_body,
s1.create_time
ORDER BY
article_id ASC
;