Need to understand about the uniqueness of idvisitor column in the database.
By running the below query, against one idvisitor, multiple devices can be seen in some scenarios, sometimes on the same date. What is the logic behind this? As it is my understanding that one device/person will have a unique idvisitor value
from matomo_log_visit mlv
group by idvisitor