Choose all selected sites of an visitor


#1

Hello,

i want to get all the visited sites of a visitor and tried this, which shows all entries:


SELECT * FROM `piwik_log_visit` visit
INNER JOIN `piwik_log_link_visit_action` link ON visit.idvisitor = link.idvisitor
INNER JOIN `piwik_log_action` action ON link.idvisit = action.idaction

The first entry has idvisitor = efbfbdefbfbdefbf. But when i try to choose only this, i get no entries:


SELECT * FROM `piwik_log_visit` visit
INNER JOIN `piwik_log_link_visit_action` link ON visit.idvisitor = link.idvisitor
INNER JOIN `piwik_log_action` action ON link.idvisit = action.idaction
WHERE visit.idvisitor = HEX("efbfbdefbfbdefbf")

Is idvisitor formatted or what could be my mistake? thanks


(Matthieu Aubry) #2

Please use the APIs instead: Reporting API Reference: API Reference - Matomo Analytics (formerly Piwik Analytics) - Developer Docs - v3

This will make it easier and return the already clean data