The logic here should be:
- Count the distinct number of children who had any child location records that
- started before the end of the selected timeframe and
- ended after the start of the selected timeframe (use
TODAY() as the default for the end) and
- were not 'with parent'.
The logic here should be:
TODAY()as the default for the end) and