@j @lanodan @hj this

select ap_id from users join (select following_id from following_relationships where follower_id = (select id from users where nickname = 'CHANGE ME')) as _user on users.id = _user.following_id;