In short this was what I tried to do.

from(q in query,
      join:
        va in ^from(va in VideoAnalysis,
          where: va.id == ^video_id,
          limit: 1,
          order_by: [desc: :inserted_at]
        ),
      join: v in assoc(va, :video),
      where: v.id == ^video_id
    )

But soon found that …

 ** (Ecto.QueryError) ....query.ex:108: queries in joins can only have `where` conditions in query:

     from c in Clip,
       join: v0 in ^#Ecto.Query<from v in VideoAnalysis, where: v.id == ^7275, order_by: [desc: v.inserted_at], limit: 1>,
       join: v1 in assoc(v0, :video),
       where: v1.id == ^7275
       select: c

trying to figure out how I can query for all the records of a thing through an intermediate record.
IE say I have a VideoAnalysis record that belongs_to a video and has many clips.
How can I query for all the clips of a video analysis if all I know if the video id?

But there is a catch in my case join: video_analysis in assoc(c, :video_analysis), would return multiple records.

Q: How could I make it to where I can limit it to only the newest based on inserted at for VideoAnalysis
in short I’m trying to do all this in the Ecto Query with just one query
if that is even possible