[rpsw]

On the face of it, your query seems simple (in C#, should be easy to translate):

  var releases = db.Releases.Where(r => r.Build.Mainline.MainlineID == 4);

Or am I missing something?