The planter count is wrong

[dadiorchen]

API: https://prod-k8s.treetracker.org/reporting/capture/statistics?capture_created_start_date=1970-01-01&capture_created_end_date=2023-05-26

the response is wrong, the correct planter count is: 11xx

planters: {
    planters: [{name: "FCCYAR", number: "220"}, {name: "FCCFED", number: "209"}, {name: "FCC", number": "96"}],
   total: 1061
}

[Kpoke]

@dadiorchen Can you send the query you used to get 11xx in the database?

[dadiorchen]

I think is this one: get all planter under 178 (freetown)

select count(*) from planter where organization_id in (select entity_id from getEntityRelationshipChildren(178));

@sebastiangaertner I remember it is you raised this problem, can you confirm?