Error: Error: Unknown column 'p.sku' in 'where clause'<br/>Error No: 1054<br/>
				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 < NOW()) 
							AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) 
						ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1
					) discount, 
					(
						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 < NOW()) 
							AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) 
						ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1
					) special, 
					pw.viewed as `p.viewed`,
					if (p.quantity, 1, 0) in_stock 			
			 FROM `oc_product` p 
					LEFT JOIN oc_product_viewed pw ON (p.product_id = pw.product_id)
				 
			LEFT JOIN `oc_product_description` pd ON (p.product_id = pd.product_id)
			LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id)
			WHERE 
				p.status = '1' 

			 AND (`p`.`quantity` > 0 OR `p`.`stock_status_id` NOT IN (14))	
			
				AND p.date_available <= NOW() 
				AND p2s.store_id = '0'
				AND pd.language_id = '2'
		 AND (  pd.name LIKE '%q%' AND  pd.name LIKE '%acoustics%' AND  pd.name LIKE '%50%' OR pd.description LIKE '%q acoustics 50%' OR  pd.tag LIKE '%q%' AND pd.tag LIKE '%acoustics%' AND pd.tag LIKE '%50%' OR LCASE(p.model) LIKE '%q acoustics 50%' OR LCASE(p.sku) = 'q acoustics 50' OR LCASE(p.upc) = 'q acoustics 50' OR LCASE(p.ean) = 'q acoustics 50' OR LCASE(p.jan) = 'q acoustics 50' OR LCASE(p.isbn) = 'q acoustics 50' OR LCASE(p.mpn) = 'q acoustics 50') AND (`p`.`quantity` > 0 OR `p`.`stock_status_id` NOT IN (14)) GROUP BY p.product_id ORDER BY  (CASE WHEN special IS NOT NULL THEN special WHEN discount IS NOT NULL THEN discount ELSE p.price END) ASC, LCASE(pd.name) ASC LIMIT 0, 12
File: /home/hifiplus/it-development.hifiplus.be/system/library/db/mysqli.php
Line: 122

Backtrace: 0
File: /home/hifiplus/it-development.hifiplus.be/system/library/db.php
Line: 54
Class: Opencart\System\Library\DB\MySQLi
Function: query

Backtrace: 1
File: /home/hifiplus/it-development.hifiplus.be/vqmod/vqcache/vq2-catalog_model_journal3_filter.php
Line: 946
Class: Opencart\System\Library\DB
Function: query

Backtrace: 2
File: /home/hifiplus/it-development.hifiplus.be/vqmod/vqcache/vq2-system_engine_loader.php
Line: 343
Class: ModelJournal3Filter
Function: getProducts

Backtrace: 3
File: /home/hifiplus/it-development.hifiplus.be/system/engine/proxy.php
Line: 87
Class: Opencart\System\Engine\Loader
Function: Opencart\System\Engine\{closure}

Backtrace: 4
File: /home/hifiplus/it-development.hifiplus.be/catalog/controller/journal3/event/products.php
Line: 46
Class: Opencart\System\Engine\Proxy
Function: __call

Backtrace: 5
File: /home/hifiplus/it-development.hifiplus.be/system/engine/action.php
Line: 96
Class: ControllerJournal3EventProducts
Function: model_catalog_product_getProducts_after

Backtrace: 6
File: /home/hifiplus/it-development.hifiplus.be/system/engine/event.php
Line: 72
Class: Opencart\System\Engine\Action
Function: execute

Backtrace: 7
File: /home/hifiplus/it-development.hifiplus.be/vqmod/vqcache/vq2-system_engine_loader.php
Line: 350
Class: Opencart\System\Engine\Event
Function: trigger

Backtrace: 8
File: /home/hifiplus/it-development.hifiplus.be/system/engine/proxy.php
Line: 87
Class: Opencart\System\Engine\Loader
Function: Opencart\System\Engine\{closure}

Backtrace: 9
File: /home/hifiplus/it-development.hifiplus.be/catalog/controller/product/search.php
Line: 185
Class: Opencart\System\Engine\Proxy
Function: __call

Backtrace: 10
File: /home/hifiplus/it-development.hifiplus.be/system/engine/action.php
Line: 96
Class: Opencart\Catalog\Controller\Product\Search
Function: index

Backtrace: 11
File: /home/hifiplus/it-development.hifiplus.be/system/framework.php
Line: 259
Class: Opencart\System\Engine\Action
Function: execute

Backtrace: 12
File: /home/hifiplus/it-development.hifiplus.be/index.php
Line: 24
Function: require_once