Mysql data read

Support & Bugs
1

Hello all,

I want to find “Pageviews” in the Database from Piwik - Page titles and work with it on Mysql.

How can i do it ?

Thx for help

2
  1. You should use the API
  2. All page views are in log_visit and log_visit_action
3

I have a Website with 2 Languages.

German and English.

I want to join the Pageviews in Page titles from the German Title and the English title. And save this in the database.

How can i do this ?

Example:

German-Title1 ::: Page views (5)
English-Title 1 ::: Page views (7)

===

German-Title1 ::: Page views (13)
English-Title 1 ::: Page views (0) === Deleted

Hope you understand my example