mySQL Error (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 m.is_active = 1 AND m.is_deleted = 0
AND c1.is_active = 1 AND c1.is_delete' at line 10
Error occurred while running query:
SELECT m.id_model, CONCAT('',m.permalink) AS href, CONCAT(m.title) AS title, IF(m.catalogue_number!='', CONCAT('', m.catalogue_number), '') AS catalogue_number,
m.summary, IF(m.thumbnail='', 'common/images/thumb_solucion.jpg', CONCAT('files/models/thumbnail/',m.thumbnail)) AS thumbnail, m.price, m.currency , m.presentation, m.net_content, b.title as marca,
(SELECT CONCAT( 'productos/',(SELECT c2.permalink FROM contents c2 WHERE c2.is_deleted=0 AND c2.id_content = c1.id_parent ),'/', c1.permalink)
) AS hrefpadre
FROM models AS m
LEFT JOIN brands AS b ON b.id_brand = m.id_brand
LEFT JOIN contents AS c1 ON c1.id_content = m.id_content
WHERE m.id_brand = AND m.is_active = 1 AND m.is_deleted = 0
AND c1.is_active = 1 AND c1.is_deleted = 0
ORDER BY m.slot ASC
PRODUCTO
PRESENTACIÓN
CONTENIDO
CÓDIGO