Error: Table '10w40.product_discount' doesn't exist<br />Error No: 1146<br />SELECT DISTINCT 
		*
		, pd.name AS name
		, p.image
		, m.name AS manufacturer
		, (
		SELECT price 
		FROM product_discount pd2 
		WHERE 
		pd2.product_id = p.product_id 
		AND pd2.customer_group_id = '1' 
		AND pd2.quantity = '1' 
		AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) 
		AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) 
		ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1
		) AS discount
		, (
		SELECT price 
		FROM product_special ps 
		WHERE 
		ps.product_id = p.product_id 
		AND ps.customer_group_id = '1' 
		AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) 
		AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) 
		ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special
		, (SELECT points FROM product_reward pr 
		WHERE 
		pr.product_id = p.product_id 
		AND customer_group_id = '1') AS reward
		, (
		SELECT ss.name 
		FROM stock_status ss 
		WHERE 
		ss.stock_status_id = p.stock_status_id 
		AND ss.language_id = '1') 
		AS stock_status
		, (
		SELECT ssp.name 
		FROM stock_status ssp 
		WHERE 
		ssp.stock_status_id = p.stock_presence_id 
		AND ssp.language_id = '1') AS stock_presence
		, (
		SELECT wcd.unit 
		FROM weight_class_description wcd 
		WHERE 
		p.weight_class_id = wcd.weight_class_id 
		AND wcd.language_id = '1') AS weight_class
		, (	SELECT lcd.unit FROM length_class_description lcd 	WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class
		, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating
		, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews
		, p.sort_order FROM product p 
		LEFT JOIN product_description pd ON (p.product_id = pd.product_id) 
		LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) 
		LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) 
		WHERE 
		p.product_id = '1504230' 
		AND pd.language_id = '1' 
		#AND p.status = '1'  #to show disabled products
		#AND p.date_available <= NOW() 
		AND p2s.store_id = '0'