CREATE MATERIALIZED VIEW public.historico_coleta_peso_categoria
TABLESPACE pg_default
AS SELECT DISTINCT ON (union_inf_about_animal_ordered.animais_id, union_inf_about_animal_ordered.date_op) union_inf_about_animal_ordered.animais_id,
    union_inf_about_animal_ordered.implantations_id,
    union_inf_about_animal_ordered.date_op,
    union_inf_about_animal_ordered.peso,
    union_inf_about_animal_ordered.categoria,
    union_inf_about_animal_ordered.src,
    union_inf_about_animal_ordered.src_id
   FROM ( SELECT union_inf_about_animal.animais_id,
            union_inf_about_animal.implantations_id,
            to_timestamp(union_inf_about_animal.dt_op)::date AS date_op,
            union_inf_about_animal.peso,
            union_inf_about_animal.categoria,
            union_inf_about_animal.src,
            union_inf_about_animal.src_id
           FROM ( SELECT inf_todos_animais.animais_id,
                    inf_todos_animais.implantations_id,
                    inf_todos_animais.dt_op,
                    inf_todos_animais.peso,
                    inf_todos_animais.categoria,
                    inf_todos_animais.src,
                    inf_todos_animais.src_id
                   FROM ( SELECT ap.animais_id,
                            ap.implantations_id,
                            ap.dt_pesagem AS dt_op,
                            ap.peso,
                            NULL::integer AS categoria,
                            'animais_peso'::text AS src,
                            ap.id AS src_id
                           FROM animais_peso ap
                        UNION ALL
                         SELECT am.animal_id,
                            am.implantations_id,
                            am.dt_operacao AS dt_op,
                            am.peso,
                            NULL::integer AS categoria,
                            'animais_movimentacoes'::text AS src,
                            am.id AS src_id
                           FROM animais_movimentacoes am
                        UNION ALL
                         SELECT al.animais_id,
                            al.implantations_id,
                            al.dt_register AS dt_op,
                            NULL::numeric(18,4) AS peso,
                            al.categoria_animal,
                            'animais_log'::text AS src,
                            al.id AS src_id
                           FROM animais_log al) inf_todos_animais
                     LEFT JOIN animais a ON a.id = inf_todos_animais.animais_id
                  WHERE a.status = ANY (ARRAY['-7'::integer, '-3'::integer, 0, 1, 10])) union_inf_about_animal
          ORDER BY union_inf_about_animal.animais_id, (to_timestamp(union_inf_about_animal.dt_op)::date), union_inf_about_animal.peso DESC) union_inf_about_animal_ordered
WITH DATA;