Can not execute database query.
Details:
Error code: 42S22
Error info: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pc.pid' in 'on clause'
Query:
SELECT DISTINCT p.pid
FROM products AS p
INNER JOIN products_categories AS oc ON pc.pid = p.pid AND pc.cid=36
INNER JOIN catalog AS c ON p.cid=c.cid AND c.is_visible="Yes"
WHERE p.is_visible="Yes" AND p.product_id <> "gift_certificate" AND
(
-- No stock control, pull the data
p.inventory_control = "No"
OR
-- Has any stock at all
p.stock > 0
OR
-- Has Display Out Of Stock rule
p.inventory_rule = "OutOfStock"
OR
(p.inventory_control = "AttrRuleInc" AND p.stock >= 0)
)