See Query Builder join on parameter value not column. This needs a join on parameter value, or a subquery