Throw fireball isn't working in multiplayer

execute as @e[type=ender_pearl, nbt={Item:{tag:{fireball:1b}}}] as @p[sort=nearest, limit=1] at @s anchored eyes run function test:fireball_throw
    execute as @e[type=dragon_fireball, tag=player, tag=!motion] at @s rotated as @p run function test:fireball_motion
    execute as @e[type=fireball, tag=player, tag=!motion] at @s rotated as @p[sort=nearest, limit=1] run function test:fireball_motion

Ok so I followed a tutorial to do this and it's working fine in singleplayer but somehow in multiplayer the game mistakes the players who throw the fireball. I've tried to specify with [sort=nearest, limit=1] but is still not working correctly