Avance con query de Guias

[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",
"Guia->Idiomas"."id" AS "Guia.Idiomas.id",
"Guia->Idiomas"."nombre" AS "Guia.Idiomas.nombre",
"Guia->Idiomas"."createdAt" AS "Guia.Idiomas.createdAt",
"Guia->Idiomas"."updatedAt" AS "Guia.Idiomas.updatedAt",
"Guia->Idiomas"."deletedAt" AS "Guia.Idiomas.deletedAt",
"Guia->Idiomas->IdiomaGuia"."createdAt" AS "Guia.Idiomas.IdiomaGuia.createdAt",
"Guia->Idiomas->IdiomaGuia"."updatedAt" AS "Guia.Idiomas.IdiomaGuia.updatedAt",
"Guia->Idiomas->IdiomaGuia"."IdiomaId" AS "Guia.Idiomas.IdiomaGuia.IdiomaId",
"Guia->Idiomas->IdiomaGuia"."GuiumId" AS "Guia.Idiomas.IdiomaGuia.GuiumId"
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 "Guia->Idiomas->IdiomaGuia"
INNER JOIN "Idiomas" AS "Guia->Idiomas" ON "Guia->Idiomas"."id" = "Guia->Idiomas->IdiomaGuia"."IdiomaId") ON "Guia"."id" = "Guia->Idiomas->IdiomaGuia"."GuiumId"
AND ("Guia->Idiomas"."deletedAt" IS NULL)
where "Persona"."identificacion" ILIKE '%santi%'
OR "Persona"."nombre" ILIKE '%santi%'
OR "Persona"."apellido" ILIKE '%santi%'
OR "Persona"."localidad" ILIKE '%santi%'
OR TO_CHAR("Persona"."fecha_nacimiento",'YYYY-MM-DD') LIKE '%santi%'
OR "Persona"."direccion" ILIKE '%santi%'
OR "Guia->Idiomas"."nombre"::text ILIKE '%santi%'
ORDER BY "id" ASC