with recursive degree  as (
    select  actor.name,actor_id, 1 as n from acting
    inner join actor on acting.actor_id = actor.id
    where movie_id in (select movie_id from acting where actor_id = %d ) and actor_id <> %d

    UNION

    select  actor.name, a2.actor_id,(n+1) as n from acting a1
    inner join actor on actor.id = a1.actor_id
    inner join degree on degree.actor_id = a1.actor_id
    inner join acting a2 on a1.movie_id = a2.movie_id

    and n < 6

)select actor.name,actor_id,n from degree inner join actor on actor.id = degree.actor_id and actor.id <> %d order by n asc, name asc;;
"