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 = 3501 AND ma027Estado = 0 AND ma0270˴ = ORDER BY ma0278~N*b Invalid utf8 character string: 'ma027\xBF\x8D0\x82\x8E\xBD\xF2\xCB\xB4\x97\xAB'