USP_DATALIST_FAF_SITEIMAGES

            CREATE procedure dbo.USP_DATALIST_FAF_SITEIMAGES
                (
                    @ALBUMOWNERGUID uniqueidentifier = null,
                    @IMAGEALBUMID int = null,
                    @SITEIMAGESID int = null,
                    @IMAGEOWNERID int = null
                )
            as
                set nocount on;

                select 
                    I.ID as SITEIMAGESID,
                    I.NAME as IMAGENAME,
                    I.FILENAME,
                    I.UPLOADFILENAME,
                    I.IMAGETYPE,
                    I.IMAGESIZE,
                    I.IMAGECONTENT,
                    I.GUID as IMAGEGUID,
                    I.OWNERID as IMAGEOWNERID,
                    I.FOLDERID,
                    I.CAPTION,
                    I.APPROVED,
                    I.PRIVATE,
                    I.PHOTOGRAPHER,
                    I.PHOTODATETAKEN,
                    A.ID as IMAGEALBUMID,
                    A.DisplayName as ALBUMNAME,
                    A.Description as ALBUMDESCRIPTION,
                    A.owneruserId as ALBUMOWNERID,
                    AE.OWNERGUID as ALBUMOWNERGUID,
                    AE.OWNERTYPE as ALBUMOWNERTYPE                        

                from dbo.IMAGEALBUM A WITH (NOLOCK)
                INNER JOIN dbo.IMAGEALBUMEXTENSION AE WITH (NOLOCK)
                ON A.ID = AE.IMAGEALBUMID
                INNER JOIN dbo.IMAGEALBUM_IMAGES IA WITH (NOLOCK)
                ON A.ID = IA.IMAGEALBUMID
                INNER JOIN dbo.SITEIMAGES I WITH (NOLOCK)
                ON I.ID = IA.SITEIMAGEID
                where 
                    AE.OWNERGUID = ISNULL(@ALBUMOWNERGUID,AE.OWNERGUID)
                    AND A.ID = ISNULL(@IMAGEALBUMID,A.ID)
                    AND I.ID = ISNULL(@SITEIMAGESID,I.ID)
                    AND I.OWNERID = ISNULL(@IMAGEOWNERID,I.OWNERID)
                    AND A.deleted = 0
                    AND I.deleted = 0
                    AND A.albumType = 3