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 'AND `prosub`.`prosub_visible` = 1' at line 9

SELECT count(pro_codigo) as cantidad FROM (`producto` as pro) LEFT JOIN `producto_subclase` as prosub ON `prosub`.`prosub_producto` = `pro`.`pro_codigo` LEFT JOIN `subclases` as scla ON `scla`.`scla_codigo` = `prosub`.`prosub_subclase` LEFT JOIN `clases` as cla ON `cla`.`cla_codigo` = `scla`.`scla_clase` LEFT JOIN `lineas` as lin ON `lin`.`lin_codigo` = `cla`.`cla_linea` LEFT JOIN `marca` as mar ON `mar`.`mar_codigo` = `pro`.`pro_marca` WHERE `pro_precio_real` != 0 and pro_estado = 1 and pro_estado = 1 and pro_visible = 1 and scla_codigo = 207/ AND `prosub`.`prosub_visible` = 1

Filename: /home/coopelancomercia/public_html/modules/productos/models/get_productos_model.php

Line Number: 84