Piwik is a great app, wo do like it.
According to the
API Response: Metric Definitions
nb_actions - Number of actions (page views, outlinks and downloads)
And I execute query like below on table
) from piwik_log_visit where idsite=5 and date_add(visit_last_action_time, interval 8 hour)>="2016-07-01 00:00:00" and date_add(visit_last_action_time, interval 8 hour)<"2016-07-02 00:00:00"
But the query result
1236 greater than
1219 which showed on the dashboard.
visit_total_actions contains pageviews, downloads and outlinks, so how can I get the exact pageviews when execute sql query.
have you seen our Mysql guide: http://developer.piwik.org/guides/persistence-and-the-mysql-backend
For example this page lists all the action types which is maybe what you need: http://developer.piwik.org/guides/persistence-and-the-mysql-backend#action-types
please note we recommend to use the Reporting APIs instead of direct SQL access: http://developer.piwik.org/api-reference/reporting-api
If you have further Piwik DB SQL queries feel free to ask in our forums: http://forum.piwik.org/