Hi,
This error message doesn't mean anything to me. It looks like a generic SQL error. It can be anything. Most likely it is related to VM Core or wrongly configured product-price establishment. Make sure all products have prices and you use same currency for them.
For testing, create a new category, then create new 1 or 2 products in this new category (make sure those products have positive prices). Then see the front-end if you are still having any SQL error message with those newly created category with the newly created products.
If error remains; try the "Install or if necessary update tables" button on "Virtuemart Backend >> Tools >> Tools & Migration" page
BE CAUTIOUS!!! The buttons on this page should be used very carefully, you might accidentally remove your Virtuemart products/categories and get back to factory settings. I would highly recommend you to BACKUP first!!!
Regards.