Describe the bug
I tried creating a dashboard to capture my weekly milage using the following query:

SELECT sum("distance") FROM "ActivitySummary" WHERE ("activityType"::field = 'running') AND time >= 1751551274130ms and time <= 1752760874130ms GROUP BY time(7d,4d)

However, it reported more km's than I expected when comparing to for instance strava's weekly reports.

I don't know why but two runs appear twice in my InnoDB and they are not recorded with my Garmin Fenix 7X but with my ... smart scale? The Index S2 is what I use to record my weight and apparently it shows up somehow somewhere.

Logs

> SELECT Activity_ID,Device,Device_ID,activityName,activityType,distance,elapsedDuration FROM "ActivitySummary" WHERE ("activityType"::field = 'running') AND time >= 1744959943017ms and time <= 1752760874130ms

[[ .. ]]
1752158446000000000 19691180247 Index™ S2 Smart Scale   3429312501 Enschede - 7 x 3m 15k                 running      8643.6796875      3733.89697265625
1752158446000000000 19691180247 fenix 7X Sapphire Solar 3429312501 Enschede - 7 x 3m 15k                 running      8643.6796875      3733.89697265625
1752220277000000000 19697611766 Index™ S2 Smart Scale   3429312501 Enschede - Base                       running      5569.8798828125   2180.2890625
1752220277000000000 19697611766 fenix 7X Sapphire Solar 3429312501 Enschede - Base                       running      5569.8798828125   2180.2890625

Are you using docker?

• Yes (compose via the easy install option)

Are you using a VPN?

• No

Did you read the README and tried to Troubleshoot?
Yes, I imported older data (from january until now) and read in the README that due to the usage of two columns as primary keys, duplicates should not happen. It appears device_id isn't used for that.

Additional context

I have a Garmin S2 smart scale :-)

I solved my case by WHERE Device='fenix 7X Sapphire Solar' but I'm not sure how that data got there in the first place