spGetUnapprovedSiteImages

    CREATE PROCEDURE dbo.spGetUnapprovedSiteImages
        (
            @ClientSitesId int
        )
    AS
        select     dbo.SiteImages.ClientSitesID,
            dbo.SiteImages.OwnerID, 
            dbo.SiteImages.Name, 
            dbo.SiteImages.Caption, 
            dbo.SiteImages.Private,
            dbo.SiteImages.UploadFileName, 
            dbo.SiteImages.ImageType, 
            dbo.SiteImages.ImageSize, 
            dbo.SiteImages.ImageContent, 
            dbo.SiteImages.Approved, 
            dbo.SiteImages.Guid, 
            dbo.SiteImages.Deleted, 
            dbo.SiteImages.ID

        FROM dbo.ClientUsers 
            INNER JOIN
            dbo.SiteImages 
        ON dbo.ClientUsers.ID = dbo.SiteImages.OwnerID
        where dbo.SiteImages.ClientSitesID = @ClientSitesID 
        and approved=0 
    and dbo.SiteImages.deleted=0
        order by [Name]
        RETURN