"Best Viewed Products" gives me too much credit

[mimages]

The "Best Viewed Products" report page in the admin screen says I have 414 products, when in fact I have only 207 (I ran a SQL statement in MyPHPadmin to find out). I have two languages installed. Could this be due to that fact?

 

By the way, for the curious, the SQL statement is here:

 

SELECT Count( products_id ) AS ProdCount FROM `products`

[joeyjgarcia]

Try adding "where language_id=1"

 

I think that is what it is for English.

 

Joey

[mimages]

That did it. Thanks. I may as well uninstall the 2nd language, I'm not ready to us it yet.

 

Thanks again.