SELECT "ACTION"."id", "ACTION"."userID", "ACTION"."title", "ACTION"."description", "ACTION"."lostDate", "ACTION"."findingDate", "ACTION"."actionIPP", "ACTION"."actionRP", "ACTION"."fi
ndingPoint", "ACTION"."statusID", "ACTION"."createdAt", "ACTION"."updatedAt", "ACTION"."lostID", "lost"."id" AS "lost.id", "lost"."firstName" AS "lost.firstName", "lost"."lastName" AS "lost.lastName", "lo
st"."descripiton" AS "lost.descripiton", "lost"."age" AS "lost.age", "lost"."sex" AS "lost.sex", "lost"."createdAt" AS "lost.createdAt", "lost"."updatedAt" AS "lost.updatedAt", "analysis"."id" AS "analysi
s.id", "analysis"."actionID" AS "analysis.actionID", "analysis"."description" AS "analysis.description", "analysis"."analysisIPP" AS "analysis.analysisIPP", "analysis"."analysisRP" AS "analysis.analysisRP
", "analysis"."createdAt" AS "analysis.createdAt", "analysis"."updatedAt" AS "analysis.updatedAt", "analysis.profiles"."id" AS "analysis.profiles.id", "analysis.profiles"."personalityID" AS "analysis.prof
iles.personalityID", "analysis.profiles"."weight" AS "analysis.profiles.weight", "analysis.profiles"."createdAt" AS "analysis.profiles.createdAt", "analysis.profiles"."updatedAt" AS "analysis.profiles.upd
atedAt", "analysis.profiles"."analysisID" AS "analysis.profiles.analysisID", "analysis.profiles.personality"."id" AS "analysis.profiles.personality.id", "analysis.profiles.personality"."name" AS "analysis
.profiles.personality.name", "analysis.profiles.personality"."active" AS "analysis.profiles.personality.active", "analysis.profiles.personality"."createdAt" AS "analysis.profiles.personality.createdAt", "
analysis.profiles.personality"."updatedAt" AS "analysis.profiles.personality.updatedAt", "analysis.model"."id" AS "analysis.model.id", "analysis.model"."modelTypeID" AS "analysis.model.modelTypeID", "anal
ysis.model"."modelStatusID" AS "analysis.model.modelStatusID", "analysis.model"."createdAt" AS "analysis.model.createdAt", "analysis.model"."updatedAt" AS "analysis.model.updatedAt", "analysis.model"."ana
lysisID" AS "analysis.model.analysisID", "analysis.model.model_type"."id" AS "analysis.model.model_type.id", "analysis.model.model_type"."modelName" AS "analysis.model.model_type.modelName", "analysis.mod
el.model_type"."active" AS "analysis.model.model_type.active", "analysis.model.model_type"."complex" AS "analysis.model.model_type.complex", "analysis.model.model_type"."createdAt" AS "analysis.model.mode
l_type.createdAt", "analysis.model.model_type"."updatedAt" AS "analysis.model.model_type.updatedAt", "analysis.model.model_status"."id" AS "analysis.model.model_status.id", "analysis.model.model_status"."
name" AS "analysis.model.model_status.name", "analysis.model.model_status"."createdAt" AS "analysis.model.model_status.createdAt", "analysis.model.model_status"."updatedAt" AS "analysis.model.model_status
.updatedAt", "analysis.model.complex_models"."id" AS "analysis.model.complex_models.id", "analysis.model.complex_models"."weight" AS "analysis.model.complex_models.weight", "analysis.model.complex_models"
."createdAt" AS "analysis.model.complex_models.createdAt", "analysis.model.complex_models"."updatedAt" AS "analysis.model.complex_models.updatedAt", "analysis.model.complex_models"."childID" AS "analysis.
model.complex_models.childID", "analysis.model.complex_models"."modelID" AS "analysis.model.complex_models.modelID", "analysis.model.complex_models.child_model"."id" AS "analysis.model.complex_models.chil
d_model.id", "analysis.model.complex_models.child_model"."modelTypeID" AS "analysis.model.complex_models.child_model.modelTypeID", "analysis.model.complex_models.child_model"."modelStatusID" AS "analysis.
model.complex_models.child_model.modelStatusID", "analysis.model.complex_models.child_model"."createdAt" AS "analysis.model.complex_models.child_model.createdAt", "analysis.model.complex_models.child_mode
l"."updatedAt" AS "analysis.model.complex_models.child_model.updatedAt", "analysis.model.complex_models.child_model.type"."id" AS "analysis.model.complex_models.child_model.type.id", "analysis.model.compl
ex_models.child_model.type"."modelName" AS "analysis.model.complex_models.child_model.type.modelName", "analysis.model.complex_models.child_model.type"."active" AS "analysis.model.complex_models.child_mod
el.type.active", "analysis.model.complex_models.child_model.type"."complex" AS "analysis.model.complex_models.child_model.type.complex", "analysis.model.complex_models.child_model.type"."createdAt" AS "an
alysis.model.complex_models.child_model.type.createdAt", "analysis.model.complex_models.child_model.type"."updatedAt" AS "analysis.model.complex_models.child_model.type.updatedAt" FROM "ACTIONs" AS "ACTIO
N" LEFT OUTER JOIN "LOSTs" AS "lost" ON "ACTION"."lostID" = "lost"."id" LEFT OUTER JOIN "ANALYses" AS "analysis" ON "ACTION"."id" = "analysis"."actionID" LEFT OUTER JOIN "PROFILEs" AS "analysis.profiles"
ON "analysis"."id" = "analysis.profiles"."analysisID" LEFT OUTER JOIN "PERSONALITies" AS "analysis.profiles.personality" ON "analysis.profiles"."personalityID" = "analysis.profiles.personality"."id" LEFT
OUTER JOIN "MODELs" AS "analysis.model" ON "analysis"."id" = "analysis.model"."analysisID" LEFT OUTER JOIN "MODEL_TYPEs" AS "analysis.model.model_type" ON "analysis.model"."modelTypeID" = "analysis.model.
model_type"."id" LEFT OUTER JOIN "MODEL_STATUSes" AS "analysis.model.model_status" ON "analysis.model"."modelStatusID" = "analysis.model.model_status"."id" LEFT OUTER JOIN "MODEL_WEIGHTs" AS "analysis.mod
el.complex_models" ON "analysis.model"."id" = "analysis.model.complex_models"."modelID" LEFT OUTER JOIN "CHILD_MODELs" AS "analysis.model.complex_models.child_model" ON "analysis.model.complex_models"."ch
ildID" = "analysis.model.complex_models.child_model"."id" LEFT OUTER JOIN "MODEL_TYPEs" AS "analysis.model.complex_models.child_model.type" ON "analysis.model.complex_models.child_model"."modelTypeID" = "
analysis.model.complex_models.child_model.type"."id" WHERE "ACTION"."id" = 444;