Severity: Warning
Message: Invalid argument supplied for foreach()
Filename: models/Search_model.php
Line Number: 174
Backtrace:
File: /home/primehost/public_html/application/models/Search_model.php
Line: 174
Function: _error_handler
File: /home/primehost/public_html/application/controllers/Search.php
Line: 39
Function: products_count
File: /home/primehost/public_html/index.php
Line: 328
Function: require_once
Error Number: 1064
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 ') ) as result' at line 11
SELECT COUNT(DISTINCT id) as countProducts FROM (SELECT `prd`.*, `prd_translate`.`title` as translate_title, `prd_translate`.`description` FROM `products` `prd` JOIN `product_translate` `prd_translate` ON prd_translate.`product` = prd.id WHERE ( `prd_translate`.`title` LIKE '%Sırğa%' OR `prd_translate`.`description` LIKE '%Sırğa%' OR `prd_translate`.`keywords` LIKE '%Sırğa%' ) AND `prd_translate`.`locale` = 'az' AND `prd`.`status` = 1 AND `prd`.`show_status` = 1 AND ) ) as result
Filename: models/Search_model.php
Line Number: 223