1064: 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 ')' at line 4 Linha : 92 Script: /home/chiccocom/public_html/class.sql.php---select count(a.pro_id) as total from produto a
inner join produto_categoria h on h.pro_id=a.pro_id
left join (select pr.pro_id, pr.pmo_perc, pr.pmo_perca, po.pmo_titulo, po.pmo_id from promocao_produto pr inner join promocao po on pr.pmo_id = po.pmo_id and po.pmo_status='1' and po.pmo_dataini<='2025-05-08 14:09:26' and po.pmo_datafim>='2025-05-08 14:09:26' group by pr.pro_id) as spr on a.pro_id=spr.pro_id
where a.pro_del<>'1' and a.pro_situacao='1' and a.pro_reserva>=0 and h.cat_id in ("40","41","42","43","44","45","56","57","76","80") and () Problema encontrado
Erro: 0L6541 Fatal error: Uncaught exception 'Exception' with message 'Houve um problema na conexão com o servidor mysql. Erro: 0L6541 -> 1064: 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 ')' at line 4 Linha : 92 Script: /home/chiccocom/public_html/class.sql.php -> select count(a.pro_id) as total from produto a
inner join produto_categoria h on h.pro_id=a.pro_id
left join (select pr.pro_id, pr.pmo_perc, pr.pmo_perca, po.pmo_titulo, po.pmo_id from promocao_produto pr inner join promocao po on pr.pmo_id = po.pmo_id and po.pmo_status='1' and po.pmo_dataini<='2025-05-08 14:09:26' and po.pmo_datafim>='2025-05-08 14:09:26' group by pr.pro_id) as spr on a.pro_id=spr.pro_id
where a.pro_del<>'1' and a.pro_situacao='1' and a.pro_reserva>=0 and h.cat_id in ("40","41","42","43","44","45","56","57","76","80") and () ' in /home/chiccocom/public_html/class.sql.php:96
Stack trace:
#0 /home/chic in /home/chiccocom/public_html/class.sql.php on line 96