USP_DATALIST_FAFEVENTS

       CREATE procedure dbo.USP_DATALIST_FAFEVENTS
       (
            @CLIENTSITESID int = null
        )
                as
                    set nocount on;
                SELECT 
                E.ID,
                E.NAME,
                E.STARTDATE,
                E.ENDDATE,
                EL.NAME LOCATIONNAME,
                EL.ADDRESSBLOCK,
                EL.CITY,
                S.ABBREVIATION STATEABBREVIATED,
        S.DESCRIPTION STATE,
        EL.POSTCODE POSTALCODE,
                C.ABBREVIATION COUNTRYABBREVIATED,
        C.DESCRIPTION COUNTRY
                FROM dbo.EVENT E (NOLOCK)
                INNER JOIN dbo.EVENTEXTENSION EX (NOLOCK)
                ON E.ID = EX.EVENTID AND (EX.CLIENTSITESID = @CLIENTSITESID OR @CLIENTSITESID is null) 
                LEFT JOIN dbo.EVENTLOCATION EL (NOLOCK)
                ON E.EVENTLOCATIONID = EL.ID 
                LEFT JOIN dbo.COUNTRY C (NOLOCK)
                ON EL.COUNTRYID = C.ID 
                LEFT JOIN dbo.STATE S (NOLOCK)
                ON EL.STATEID = S.ID
                ORDER BY E.Name