Can not execute database query.
Details:
Error code: 42S02
Error info: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'kobaci_pinnacle.products' doesn't exist
Query:
SELECT DISTINCT p.pid
FROM products AS p
INNER JOIN catalog AS c ON p.cid=c.cid AND c.is_visible="Yes"
LEFT JOIN manufacturers as m ON p.manufacturer_id = m.manufacturer_id
WHERE p.is_visible="Yes" AND p.product_id <> "gift_certificate" AND p.manufacturer_id=7 AND p.is_stealth = 0 AND
(
-- No stock control, pull the data
p.inventory_control = "No"
OR
-- Has any stock at all and stock must be >= of min_order if inventory_rule is set to Hide
((p.stock > 0 AND p.inventory_rule <> "Hide") OR (p.stock > 0 AND p.stock >= p.min_order AND p.inventory_rule = "Hide"))
OR
-- Has Display Out Of Stock rule
p.inventory_rule = "OutOfStock"
OR
(p.inventory_control = "AttrRuleInc" AND p.stock >= 0)
)