Multiple Joins "Invalid join condition"

    const playersCollection = createCollection(
        queryCollectionOptions({
            queryKey: ["jugadores", clubId],
            queryFn: async () => {
                const results = await call.get<FrappeResponse<Jugador[], { count: number }>>(
                    "setplus.setplus.doctype.jugador.jugador.get_filtered_jugadores",
                    {
                        club: clubId,

                        page_size: 9999999,
                        page: 0,
                    },
                );
                return results.message.data ?? [];
            },
            getKey: (item) => item.name,
            queryClient,
        }),
    );
    const clientsCollection = createCollection(
        queryCollectionOptions({
            queryClient,
            queryKey: ["clientes", clubId],
            queryFn: async () => {
                return await db.getDocList<Cliente>("Cliente", {
                    filters: [["club", "=", clubId]],
                    fields: ["*"],
                    limit: 9999999,
                });
            },
            getKey: (item) => item.name,
        }),
    );
    const balancesCollection = createCollection(
        queryCollectionOptions({
            queryClient,
            queryKey: ["balances", clubId],
            queryFn: async () => {
                return await db.getDocList<BalanceClientePorClub>("Balance Cliente por Club", {
                    filters: [["club", "=", clubId]],
                    fields: ["*"],
                    limit: 9999999,
                });
            },
            getKey: (item) => item.name,
        }),
    );