DROP VIEW IF EXISTS public.general_tag_album_view;
CREATE VIEW public.general_tag_album_view
AS
SELECT
  T.id as id_general_tag, T.name, T.normalized_name, SS.item_count, T.id_user
FROM
  general_tag as T, (
      SELECT count(DISTINCT(U.id_item)) AS item_count, R.id_general_tag, U.id_user
      FROM many_unit_has_many_general_tag as R, unit as U
      WHERE U.id = R.id_unit AND U.is_major = 't'
      GROUP BY R.id_general_tag, U.id_user
    ) SS WHERE T.id = SS.id_general_tag AND T.id_user = SS.id_user;