Two composite indexes might be helpful.

    CREATE INDEX PAW_IDX2099075689 ON comment(USER_ID,DELETED,NEWS_ID,PICTURE_ID,TOPIC_ID);
    CREATE INDEX PAW_IDX0500726826 ON comment(NEWS_ID,PICTURE_ID,TOPIC_ID,DELETED);

PAWSQL_IDX2099075689 can be used in outer block to do a index LOOKUP with condition(`comment.user_id = '1' and comment.deleted = 0`), and SORT AVOIDANCE for (`group by comment.topic_id, comment.picture_id, comment.news_id`).

PAWSQL_IDX0500726826 can be used in the subquery to do a index LOOKUP with condition(`p1.topic_id = p2.topic_id and p1.picture_id = p2.picture_id and p1.news_id = p2.news_id and p1.deleted = 0`).