We are having and issue with a website.
[url removed, login to view]
Over here with the printers if you select the brand Cannon, it says there are 11 products (which there are), but they aren't being showed. And if you refresh the page you'll see the products are loaded for a split second and then they disappear again. It's only with this brand. See added screenshot.
It seems the PHP fails to fetch results from a perfectly correct sql query.