<br />
<b>Fatal error</b>:  Uncaught Exception: Error: Unknown column 'ps.special' in 'WHERE'&lt;br /&gt;Error No: 1054&lt;br /&gt;
				SELECT 
					p.product_id, 
					(
						SELECT AVG(rating) total 
						FROM `review` r1 
						WHERE 
							r1.product_id = p.product_id 
							AND r1.status = '1' 
						GROUP BY r1.product_id
					) rating, 
					(
						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 &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 `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()) in <b>/home/ackits5/public_html/system/library/db/mysqli.php</b> on line <b>48</b><br />