Os seguintes erros Aconteceram:

Erro na execução da query SELECT cp.*, p.*FROM cat_prod cp INNER JOIN produtos p ON(cp.prod_id = p.pdt_id) WHERE cp.cat_id = 2 AND ( (SELECT COUNT(*) FROM produtos_filtros WHERE pf_pid = p.pdt_id AND pf_fid = 12 AND pf_val = ) = 1 ) AND ( (SELECT COUNT(*) FROM produtos_filtros WHERE pf_pid = p.pdt_id AND pf_fid = 13 AND pf_val = ) = 1 ) AND p.pdt_status = 's' limit 0, 15
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') = 1 ) AND ( (SELECT COUNT(*) FROM produtos_filtros WHERE pf_pid = p.pdt_id AND' at line 1

Detalhes:

Arquivo -> /home/unidosin/public_html/app/system/classes/database/drivers/DB_Mysqli.php

Linha -> 62






#0 CError::System(Erro na execução da query SELECT cp.*, p.*FROM cat_prod cp INNER JOIN produtos p ON(cp.prod_id = p.pdt_id) WHERE cp.cat_id = 2 AND ( (SELECT COUNT(*) FROM produtos_filtros WHERE pf_pid = p.pdt_id AND pf_fid = 12 AND pf_val = ) = 1 ) AND ( (SELECT COUNT(*) FROM produtos_filtros WHERE pf_pid = p.pdt_id AND pf_fid = 13 AND pf_val = ) = 1 ) AND p.pdt_status = 's' limit 0, 15
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') = 1 ) AND ( (SELECT COUNT(*) FROM produtos_filtros WHERE pf_pid = p.pdt_id AND' at line 1) called at [/home/unidosin/public_html/app/system/classes/database/drivers/DB_Mysqli.php:62]
#1 CDb_DB_Mysqli->Query(SELECT cp.*, p.*FROM cat_prod cp INNER JOIN produtos p ON(cp.prod_id = p.pdt_id) WHERE cp.cat_id = 2 AND ( (SELECT COUNT(*) FROM produtos_filtros WHERE pf_pid = p.pdt_id AND pf_fid = 12 AND pf_val = ) = 1 ) AND ( (SELECT COUNT(*) FROM produtos_filtros WHERE pf_pid = p.pdt_id AND pf_fid = 13 AND pf_val = ) = 1 ) AND p.pdt_status = 's' ) called at [/home/unidosin/public_html/app/system/classes/framework/model.php:88]
#2 CModel->Query(SELECT cp.*, p.*FROM cat_prod cp INNER JOIN produtos p ON(cp.prod_id = p.pdt_id) WHERE cp.cat_id = 2 AND ( (SELECT COUNT(*) FROM produtos_filtros WHERE pf_pid = p.pdt_id AND pf_fid = 12 AND pf_val = ) = 1 ) AND ( (SELECT COUNT(*) FROM produtos_filtros WHERE pf_pid = p.pdt_id AND pf_fid = 13 AND pf_val = ) = 1 ) AND p.pdt_status = 's' ) called at [/home/unidosin/public_html/includes/modulos/mod_produtos/site.php:107]
#3 CProdutos_Controller->_Listar() called at [/home/unidosin/public_html/app/system/classes/framework/controller.php:80]
#4 CController->_execute() called at [/home/unidosin/public_html/app/system/classes/aplication/site.php:74]
#5 CSite->Inicializar() called at [/home/unidosin/public_html/index.php:24]