SELECT * FROM v_group WHERE group_domain='test'