$rs = $db->resultset('Comment')->search({
    'user.name' => 'bliako',
    'me.text'   => 'good',
}, {
    join => ['user', { artwork => 'artist' }],
});

while ( my $comment = $rs->next ) {
    say sprintf('bliako likes: "%s" (%s)',
        $comment->artwork->name,
        $comment->artwork->artist->name,
    );
}