spGetUnapprovedClientUserImages

    CREATE PROCEDURE dbo.spGetUnapprovedClientUserImages
        (
            @ClientsId int
        )
    AS
        select 
            dbo.ClientUserImages.ClientUsersID, 
            dbo.ClientUserImages.Name, 
            dbo.ClientUserImages.Caption, 
            dbo.ClientUserImages.Private,
                    dbo.ClientUserImages.Sequence, 
            dbo.ClientUserImages.Category, 
            dbo.ClientUserImages.Editable, 
            dbo.ClientUserImages.UploadFileName, 
            dbo.ClientUserImages.ImageType, 
                    dbo.ClientUserImages.ImageSize, 
            dbo.ClientUserImages.ImageContent, 
            dbo.ClientUserImages.Approved, 
            dbo.ClientUserImages.Guid, 
                    dbo.ClientUserImages.OwnerID, 
            dbo.ClientUserImages.Deleted, 
            dbo.ClientUserImages.ID

        FROM         dbo.ClientUsers INNER JOIN
                        dbo.ClientUserImages ON dbo.ClientUsers.ID = dbo.ClientUserImages.ClientUsersID
        where clientsid = @clientsid and approved=0 order by Category
        RETURN