Fatal error: Uncaught Exception: Error: Table 'jerseyzone.oc_product_special' doesn't exist<br />Error No: 1146<br />SELECT DISTINCT *,
p.product_id,
pd.name,
p.image,
m.name AS manufacturer,
p.sort_order,
(SELECT price FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id
AND pd2.customer_group_id = '1'
AND pd2.quantity = 1
AND (pd2.date_start <= NOW() AND pd2.date_end >= NOW())
ORDER BY pd2.priority, pd2.price
LIMIT 1) AS discount,
(SELECT price FROM oc_product_special ps
WHERE ps.product_id = p.product_id
AND ps.customer_group_id = '1'
AND (ps.date_start <= NOW() AND ps.date_end >= NOW())
ORDER BY ps.priority, ps.price
LIMIT 1) AS special,
ss.name AS stock_status
FROM oc_product p
LEFT JOIN oc_product_description pd
ON p.product_id = pd.product_id
AND pd.language_id = '1'
LEFT JOIN oc_product_to_store p2s
ON p.product_id = p2s.product_id
AND p2s.store_id = '0'
LEFT JOIN oc_m in /www/wwwroot/wholesalejerseyzone.com/system/library/db/mysqli.php on line 41