Jump to content

Can someone help me with SQL query in sql manager?


Recommended Posts



Can someone help me creating a query?

I would like to see the number of page views per product per day or week.

I know I can see it in the stats, but there I have to click on a product to see it and I want to see it as a list, so I can compare the views per product and see the most viewed products etc.


I have no sql knowledge, so combining all tables is to difficult for me.




Link to comment
Share on other sites

Hi, I don't know if it already exists in the stats but if not, you can create a table with id_product and date fields and add a counter in the controllers/productController.php file. Each time the product page is reached, it will registered the id product and date in the new table like that you can create all requests you want on it

Edited by fred-vinapresta (see edit history)
Link to comment
Share on other sites

Sorry, i'm not a programmer but a user of the software.

In the stats there is a view per product, as stated in my first post, but i can only see one product at the time.

I don't think there has to be made any changes to software but it can be done with a query, only I don't know how to make the qsl statement


I would imagine anyone with sql knowledge would be able to post the query here?

Would greatly appreciate this.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...