inicio  /  e-shop   /  punto
Outlet
Error en: SELECT col.nombrepaginaES AS np_coleccion, prendas.nombrepaginaES AS np_prenda, prendas.prendaES AS prenda, prod.* FROM ((productos as prod INNER JOIN colecciones as col ON col.id=prod.idColeccion) INNER JOIN prendas ON prendas.id=prod.idPrenda) WHERE EXISTS (SELECT comb.id FROM ((combinaciones as comb INNER JOIN colores ON colores.id=comb.idColor) INNER JOIN tallas ON tallas.id=comb.idTalla) WHERE comb.activo AND colores.activo AND tallas.activo AND comb.idProducto=prod.id) AND EXISTS (SELECT id FROM categorias_producto as cp WHERE prod.id=cp.idProducto AND cp.idCategoria=9) AND prod.idColeccion= AND prod.activo=1 ORDER BY prioridad. 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 prod.activo=1 ORDER BY prioridad' at line 1