USP_DATALIST_EVENTPROFILEREPORT_SEATINGCOUNT

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

                    if @ISVISIBLE = 1
                        select
                            coalesce(SEATING.SECTIONCOUNT, 0) SECTIONCOUNT,
                            coalesce(SEATING.SUBSECTIONCOUNT, 0) SUBSECTIONCOUNT,
                            coalesce(SEATING.SEATCOUNT, 0) SEATCOUNT,
                            coalesce((select count(S.ID) from dbo.EVENTSEATINGSEAT S inner join dbo.EVENTSEATINGSUBSECTION SUB on S.EVENTSEATINGSUBSECTIONID = SUB.ID
                            inner join dbo.EVENTSEATINGSECTION SEC on SUB.EVENTSEATINGSECTIONID = SEC.ID where SEC.EVENTSEATINGID = SEATING.ID), 0) as TOTALSEATS 
                        from
                            dbo.EVENT
                        left join
                            dbo.EVENTSEATING SEATING on EVENT.ID = SEATING.ID
                        where
                            EVENT.ID = @EVENTID;