Left Join ON parameter value

Bumping this one as it is what I am looking for: Query Builder join on parameter value not column