A Database Error Occurred
Error Number: 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 ')
OR v.ID_CLI2 IN ()
OR v.ID_CLI3 IN ()
)
GROUP BY `v`.`PLACA`' at line 10
SELECT `v`.`PLACA`, `v`.`DESC`, `v`.`ID_CLI`, `v`.`ID_TIPO`, `v`.`SAIDA1_I`, `tv`.`TIPO`, `e`.`SERIAL` as FIRMWARE_SERIAL, `v`.`ID_VEICULO`
FROM (`veiculo` AS v)
JOIN `cliente` AS cli ON `v`.`ID_CLI` = `cli`.`ID_CLI`
JOIN `tipo_veiculo` AS tv ON `v`.`ID_TIPO` = `tv`.`ID_TIPO`
JOIN `equipamento` AS e ON `e`.`ID_EQUIP` = `v`.`ID_EQUIP` OR e.ID_EQUIP = v.ID_EQUIP2
WHERE `v`.`ID_TIPO` = tv.ID_TIPO
AND v.ID_CLI = cli.ID_CLI
AND v.STATUS = '1'
AND (
v.ID_CLI1 IN ()
OR v.ID_CLI2 IN ()
OR v.ID_CLI3 IN ()
)
GROUP BY `v`.`PLACA`
Filename: /var/www/php5.localhost/Portais/maxtec/web/models/veiculomaster_model.php
Line Number: 149