Mysql error: Unknown column 'fid' in 'where clause' File: /home/bsmarkab/public_html/static_pages/idos-mosogep_108.php Line: 3 Function: sql_q_cs Query: SELECT prod.*, IF(ddprice, ddprice, price) AS cprice, manufacturer.name AS m_name, c.name AS c_name
FROM prod
LEFT JOIN manufacturer ON prod.mid = manufacturer.mid
LEFT JOIN category AS c ON prod.cid = c.cid
WHERE active = "y" AND pid IN (SELECT pid FROM filter_prod_xref WHERE fid = 20303) ORDER BY cprice