d1001001

Eloquent query - combine "with" and "join"

Hi, is there any way to combine "with" and "join" in a single fluent query? Eg.:...

This results in columns not found. I just don't understand why it ignores everything within the with...