query para obtener todos los idiomas que habla un guia

[CarlosIrigoyen]

SELECT "Persona".*,
"Guia"."id" AS "Guia.id",
"Guia"."dias_trabaja" AS "Guia.dias_trabaja",
"Guia"."horario_trabaja" AS "Guia.horario_trabaja",
"Guia"."PersonaId" AS "Guia.PersonaId",
"Guia"."createdAt" AS "Guia.createdAt",
"Guia"."updatedAt" AS "Guia.updatedAt",
"Idiomas"."nombre" AS "Idiomas.nombre"
FROM (
SELECT "Persona"."id",
"Persona"."identificacion",
"Persona"."nombre",
"Persona"."apellido",
"Persona"."direccion",
"Persona"."localidad",
"Persona"."email",
"Persona"."fecha_nacimiento",
"Persona"."telefono",
"Persona"."createdAt",
"Persona"."updatedAt",
"Persona"."deletedAt"
FROM "Personas" AS "Persona"
WHERE "Persona"."identificacion" = '18236195'
AND "Persona"."deletedAt" IS NULL
ORDER BY "id" ASC
LIMIT 1
OFFSET 0
) AS "Persona"
LEFT OUTER JOIN "Guia" AS "Guia" ON "Persona"."id" = "Guia"."PersonaId"
AND "Guia"."deletedAt" IS NULL
LEFT OUTER JOIN "IdiomaGuia" AS "GuiaIdioma" ON "Guia"."id" = "GuiaIdioma"."GuiumId"
LEFT OUTER JOIN "Idiomas" AS "Idiomas" ON "GuiaIdioma"."IdiomaId" = "Idiomas"."id";