SELECT ma027localescomerciales.*,
ma012comerciosgaleria.ma012IdComercio, ma012comerciosgaleria.ma012NombreComercial,ma012comerciosgaleria.ma012Permalink,
ad020municipios.ad020Municipio,ad020municipios.ad020Provincia,
ad001entidades.ad001DominioGuiaAtractividadComercial,
catHija.ma041Nombre_es as subCatCCVAnterior,
(SELECT catPadre.ma041Nombre_es FROM ma041categoriasccv catPadre
WHERE catPadre.ma041Id = catHija.ma041IdPadre) as catCCVAnterior
FROM
ma027localescomerciales
LEFT JOIN ad020municipios ON ad020Id = ma027IdMunicipio
LEFT JOIN ad001entidades ON ad001Id = ma027IdCentro
LEFT JOIN ma012comerciosgaleria ON ma012IdComercio = ma027IdInmobiliariaAsociada AND ma012IdCentro = ma027IdCentro
LEFT JOIN ma041categoriasccv catHija ON catHija.ma041Id = ma027IdSubcategoriaCCVAnterior WHERE ma027Id = 459 AND ma027Estado = 0 AND ma027Öš•û`ê®*ö¼ = ORDER BY ma027w8ª]çÆ9ª 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 '??`??*?? = ORDER BY ma027w8?]??9?' at line 14