For included collections that are referenced in the where clause, we need to keep the join condition so that the where clause works, but to nullify their fields so that normalisation is not affected. This is also true of any additional collections related to a referenced collection.
For included collections that are referenced in the where clause, we need to keep the join condition so that the where clause works, but to nullify their fields so that normalisation is not affected.
This is also true of any additional collections related to a referenced collection.

silktide/reposition-sql,downsider/reposition-sql