Fatal error: Uncaught Exception: Error: Table 'jerseyzone.oc_product_description' doesn't exist<br />Error No: 1146<br />
SELECT
p.product_id,
review_stats.rating,
discount_stats.discount_price AS discount,
special_stats.special_price AS special,
p.viewed as `p.viewed`,
IF(p.quantity > 0, 1, 0) AS in_stock
FROM `oc_product` p
LEFT JOIN (
SELECT product_id, AVG(rating) AS rating
FROM `oc_review`
WHERE status = '1'
GROUP BY product_id
) review_stats ON p.product_id = review_stats.product_id
LEFT JOIN (
SELECT product_id, MIN(price) AS discount_price
FROM `oc_product_discount`
WHERE customer_group_id = '1'
AND quantity = '1'
AND (date_start = '0000-00-00' OR date_start < NOW())
AND (date_end = '0000-00-00' OR date_end > NOW())
GROUP BY product_id
) discount_stats ON p.product_id = discount_stats.product_id
LEFT JOIN (
SELECT product_id, MIN(price) AS special_price
FROM `oc_product_special`
WHERE customer_group in /www/wwwroot/wholesalejerseyzone.com/system/library/db/mysqli.php on line 41