DROP VIEW IF EXISTS public.need_convert_thumbnail_view;
CREATE VIEW public.need_convert_thumbnail_view
AS
SELECT
     u.id, u.id_user, u.filename, u.normalized_filename, u.type as unit_type, u.item_type, t.status, ARRAY_AGG(t.type)::int[] as thumbnail_type FROM unit u, thumbnail t
WHERE
   u.id = t.id_unit and (t.type = 1 or t.type = 6) and t.status = 3
GROUP BY
   u.id, u.id_user, u.type, u.item_type, t.status;