How to get Unique Downloads count from Matomo mysql table

Looking for SQL quire to get the Unique Downloads count from matomo_log_action table
as shown below

please help the way to get Unique Downloads count


Matomo doesn’t officially support making direct MySQL queries to get reports (as they are potentially not stored in a straightforward format and you end up reinventing a large portion of Matomo yourself). So I strongly recommend you to go with the HTTP API instead (you can find the API URL with the export :export: button below the report).

But if you want to you can enable SQL logging in Matomo ( and see if you can find something useful.