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 = 2260 AND ma027Estado = 0 AND ma027r/玺m = ORDER BY ma027pGZ Invalid utf8 character string: 'ma027r\xCC'