Hope all is going well.
The error message below is being displayed in some of the pricing tables on the site I’m working on. Initially the product page displays the price information correctly but as soon as the results are filtered by size the error is displayed. I haven’t seen anything like this before in the pricing table and wondered if you might be able to suggest a way to resolve it.
[SELECT merchant FROM `pt_products` WHERE merchant IN () ORDER BY rand() LIMIT 1][You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY rand() LIMIT 1' at line 1]
Thanks in advance.