SearchBuilderOptions()/SearchPaneOptions() include unrelated Left Joins

In the samples SearchBuilderController.cs adding addition joins show up in that search builder query:

      .Field(new Field("users.site")
          .Options(new Options()
              .Table("sites")
              .Value("id")
              .Label("name")
          )
      )
      .Field(new Field("sites.name")
          .SearchBuilderOptions(new SearchBuilderOptions()
              .Label("sites.name")
              .Value("sites.name")
              .LeftJoin("sites", "sites.id", "=", "users.site")
          )
      )
    .LeftJoin("sites", "sites.id", "=", "users.site")
    .LeftJoin("user_dept", "users.id", "=", "user_dept.user_id")

SELECT  sites.name as 'value', sites.name as 'label' 
FROM  users 
LEFT JOIN sites ON sites.id = users.site  
LEFT JOIN user_dept ON users.id = user_dept.user_id  
GROUP BY sites.name

Inizia con l’esempio SearchBuilderController.cs e traccia il modo in cui SearchBuilderOptions() e SearchPaneOptions() generano le query ed ereditano i join. Confronta l’SQL generato con i join dichiarati per il campo e per la query padre. Il lavoro è completato quando le clausole LEFT JOIN non correlate non compaiono più nella query del search builder.