137 

   138 CREATE OR REPLACE VIEW vmm_domain_info AS

   139     SELECT gid, domainname, transport, domaindir, count(uid) AS accounts,

   140            aliases

   141       FROM domains

   142            LEFT JOIN transport USING (tid)

   143            LEFT JOIN users USING (gid)

   144            LEFT JOIN vmm_alias_count USING (gid)

   145   GROUP BY gid, domainname, transport, domaindir, aliases;