select
  "public"."trainings"."trng_pk",
  "public"."trainings"."trng_date",
  "public"."trainings"."trng_trty_fk",
  "public"."trainings"."trng_outcome",
  "public"."trainings"."trng_start",
  "public"."trainings"."trng_comment",
  count("public"."trainings_employees"."trem_pk") as "registered",
  count("public"."trainings_employees"."trem_outcome") filter (where "public"."trainings_employees"."trem_outcome" = 'VALIDATED') as "validated",
  count("public"."trainings_employees"."trem_outcome") filter (where "public"."trainings_employees"."trem_outcome" = 'FLUNKED') as "flunked",
  ("public"."trainings"."trng_date" + ((
    select "public"."trainingtypes"."trty_validity"
    from "public"."trainingtypes"
    where "public"."trainingtypes"."trty_pk" = "public"."trainings"."trng_trty_fk"
  ) || ' month')::interval)::date,
  (
    select array_agg("public"."trainings_trainers"."trtr_empl_fk")
    from "public"."trainings_trainers"
    where "public"."trainings_trainers"."trtr_trng_fk" = "public"."trainings"."trng_pk"
  ) as "trainers",
  "public"."trainings_employees"."trem_outcome",
  "public"."trainings_employees"."trem_comment"
from "public"."trainings"
  join "public"."trainings_employees"
  on "public"."trainings_employees"."trem_trng_fk" = "public"."trainings"."trng_pk"
  join "public"."trainings_employees"
  on (
    "public"."trainings_employees"."trem_trng_fk" = "public"."trainings"."trng_pk"
    and "public"."trainings_employees"."trem_empl_fk" = '01600447'
  )
where (
  "public"."trainings"."trng_date" <= date '2016-06-25'
  or (
    "public"."trainings"."trng_start" is not null
    and "public"."trainings"."trng_start" <= date '2016-06-25'
  )
)
group by
  "public"."trainings"."trng_pk",
  "public"."trainings"."trng_date",
  "public"."trainings"."trng_trty_fk",
  "public"."trainings"."trng_outcome",
  "public"."trainings"."trng_start",
  "public"."trainings"."trng_comment",
  "public"."trainings_employees"."trem_outcome",
  "public"."trainings_employees"."trem_comment"
order by "public"."trainings"."trng_date" asc