USP_DATALIST_EVENTPROFILEREPORT_REGISTRANTRESTRICTIONSUMMARY

                CREATE procedure dbo.USP_DATALIST_EVENTPROFILEREPORT_REGISTRANTRESTRICTIONSUMMARY
                (
                    @EVENTID uniqueidentifier,
                    @ISVISIBLE bit = 1
                )
                as
                    set nocount on;

                    select
                        EVENTRESTRICTIONTYPE.NAME [EVENTRESTRICTIONTYPE],
                        EVENTRESTRICTIONOPTION.NAME [EVENTRESTRICTIONOPTION],
                        COUNT(*) [RESTRICTIONCOUNT]
                    from
                        dbo.[EVENT]
                        inner join dbo.REGISTRANT on [EVENT].ID = REGISTRANT.EVENTID
                        inner join dbo.REGISTRANTRESTRICTIONOPTION on REGISTRANT.ID = REGISTRANTRESTRICTIONOPTION.REGISTRANTID
                        inner join dbo.EVENTRESTRICTIONOPTION on REGISTRANTRESTRICTIONOPTION.EVENTRESTRICTIONOPTIONID = EVENTRESTRICTIONOPTION.ID
                        inner join dbo.EVENTRESTRICTIONTYPE on EVENTRESTRICTIONOPTION.EVENTRESTRICTIONTYPEID = EVENTRESTRICTIONTYPE.ID
                    where [EVENT].ID = @EVENTID
                    group by EVENTRESTRICTIONOPTION.NAME, EVENTRESTRICTIONTYPE.NAME
                    order by EVENTRESTRICTIONTYPE.NAME, EVENTRESTRICTIONOPTION.NAME