Sql query to get top visits For Each country

qaisibra (qais Ibrahim) May 14, 2016, 9:18am 1

hi all,
i need SQL Query to get countryFlag,countryname and Number of visits from each country DESC in specific dates ranges
Please Help!

matthieu (Matthieu Aubry) May 23, 2016, 5:45am 2

Please use API instead of direct SQL access: Reporting API Reference: API Reference - Piwik Analytics - Developer Docs - v3

1 Like

qaisibra (qais Ibrahim) May 23, 2016, 6:04am 3

I need it to understand how PIWIK works …
BTY i found it and thank you for replying !.

1 Like

Chryst_Fhea_Godoy (Chryst Fhea Godoy) September 22, 2022, 9:14am 4

Hi Can you share your query? Im interested.

heurteph-ei (Philippe) September 22, 2022, 1:00pm 5

I think you can have the start of an answer there:
https://developer.matomo.org/guides/database-schema#visits