Mysql error: 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 ') GROUP BY pid) AND p.cid IN (501) AND active = 'y' ORDER BY popularity DESC LIM' at line 3
File: /home/arbolthu/public_html/include/prod_list.php
Line: 113
Function: sql_q_cs
Query: SELECT p.*, c.name AS c_name, m.name AS m_name FROM prod AS p
LEFT JOIN category AS c ON c.cid = p.cid
LEFT JOIN manufacturer AS m ON m.mid = p.mid WHERE p.pid IN (SELECT pid FROM filter_prod_xref WHERE vfid IN () GROUP BY pid) AND p.cid IN (501) AND active = 'y' ORDER BY popularity DESC LIMIT 0, 90