A PHP Error was encountered

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

Database Error

A Database Error Occurred

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