<br />
<b>Fatal error</b>:  Uncaught Exception: Error: Not unique table/alias: 'pd'&lt;br /&gt;Error No: 1066&lt;br /&gt;
				SELECT SQL_CALC_FOUND_ROWS 
					p.product_id,
					p.model,
					p.price,
					p.quantity,
					pd.name,
					COALESCE(r.rating, 0) as rating,
					pd_discount.price as discount,
					ps_special.price as special,
					p.viewed as `p.viewed`,
					IF(p.quantity &gt; 0, 1, 0) as in_stock
				FROM `oc_product` p
				INNER JOIN `oc_product_description` pd ON (p.product_id = pd.product_id)
				LEFT JOIN (
					SELECT product_id, AVG(rating) as rating 
					FROM `oc_review` 
					WHERE status = '1' 
					GROUP BY product_id
				) r ON (p.product_id = r.product_id)
				LEFT JOIN (
					SELECT 
						product_id, 
						MIN(price) as price
					FROM `oc_product_discount`
					WHERE customer_group_id = '1'
					AND quantity = '1'
					AND ((date_start = '0000-00-00' OR date_start &lt; NOW())
					AND (date_end = '0000-00-00' OR date_end &gt; NOW()))
					GROUP BY product_id
				) pd_discount ON (p.product_id = pd_discount.product_id)
				LEFT in <b>/www/wwwroot/wholesalejerseyzone.com/storage/modification/system/library/db/mysqli.php</b> on line <b>53</b><br />