<br />
<b>Fatal error</b>:  Uncaught Exception: Error: Incorrect DATE value: '0000-00-00'&lt;br /&gt;Error No: 1525&lt;br /&gt;
			SELECT 
				p.product_id, 
				(
					SELECT AVG(rating) total 
					FROM `oc_review` r1 
					WHERE 
						r1.product_id = p.product_id 
						AND r1.status = '1' 
					GROUP BY r1.product_id
				) rating, 
				(
					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 = '0000-00-00' OR pd2.date_start &lt; NOW()) 
						AND (pd2.date_end = '0000-00-00' OR pd2.date_end &gt; NOW())) 
					ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1
				) 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 = '0000-00-00' OR ps.date_start &lt; NOW()) 
						AND (ps.date_end = '0000-00-00' OR ps.date_end &gt; NOW())) 
					ORDER BY ps.priority ASC, ps.price ASC LIMIT 1
				) sp in <b>/home/zbxnjzmn/calin.website/system/library/db/mysqli.php</b> on line <b>41</b><br />