Query para teaer todos los guias que hablan un idiom dado ( tambien trea los demas idiomas que habla el 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",
      "Guia"."deletedAt" AS "Guia.deletedAt",
      STRING_AGG("Idiomas"."nombre",',') AS "Idiomas"
      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"."deletedAt" IS NULL
      ORDER BY "id" ASC
      LIMIT 10
      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"
      WHERE EXISTS (
      SELECT 1
      FROM "IdiomaGuia" AS "GuiaIdioma"
      JOIN "Idiomas" AS "Idiomas" ON "GuiaIdioma"."IdiomaId" = "Idiomas"."id"
      WHERE "GuiaIdioma"."GuiumId" = "Guia"."id"
      AND "Idiomas"."nombre" ILIKE '%inglés%'
      )GROUP BY "Guia"."id","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"