Black Friday akció

Mysql error: Column 'active' in where clause is ambiguous
File: /home/bsmarka1/elektromarkabolt/static_pages/black-friday_219.php
Line: 9
Function: sql_q_cs
Query: SELECT prod.*, IF(prod.ddprice, prod.ddprice, prod.price) AS cprice, manufacturer.name AS m_name, c.name AS c_name FROM sale_prod AS sp LEFT JOIN prod ON prod.pid = sp.pid LEFT JOIN manufacturer ON prod.mid = manufacturer.mid LEFT JOIN category AS c ON prod.cid = c.cid WHERE active = "y" AND sp.stockpile > 0 ORDER BY cprice