This query only joins on author_user_id / network_user_id, but not network. What if there are two instances from different networks with the same user ID? It's unlikely, but it is possible.