<br />
<b>Fatal error</b>:  Uncaught Exception: Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Discipline '%Chinelo%' AND pd.tag Discipline '%Havaianas%' AND pd.tag Discipl...' at line 39&lt;br /&gt;Error No: 1064&lt;br /&gt;SELECT 
				p.hideprice, 
				p.product_id, 
				p.product_redden, 
				(
					SELECT AVG(rating) 
					FROM glh_review r1 
					WHERE r1.product_id = p.product_id 
					  AND r1.status = '1' 
					GROUP BY r1.product_id
				) AS rating, 
				(
					SELECT price 
					FROM glh_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
				) AS discount, 
				(
					SELECT price 
					FROM glh_product_special ps 
					WHERE ps.product_id = p.product_id 
	 in <b>/var/www/html/storebrciandtcom/upload/system/library/db/mysqli.php</b> on line <b>123</b><br />