SupabaseS
Supabase2y ago
loup

Limited number of inner join during query

There is a limits of tables we can join during query ? Because making this :
const { data: movie} = await supabase
    .from('tmdb_movie')
    .select('*,translate:tmdb_movie_translation!inner(*),videos:tmdb_movie_videos(*)),genres:tmdb_movie_genre(id))')
    .eq('id', params.film)
    .eq('translate.language_id', params.lang)
    .eq('videos.iso_639_1', params.lang)
    .single();

I can't find genres folder, and if I put the genres before videos, I dont have videos folder
Was this page helpful?