USP_DATALIST_AUCTIONITEMCOPY

                CREATE procedure dbo.USP_DATALIST_AUCTIONITEMCOPY
                (
                    @CONTEXTID uniqueidentifier = null
                )
                as
                    set nocount on;

                    select AUCTIONITEM.ID,
                           AUCTIONITEM.NAME,
                           AUCTIONITEMCATEGORY.NAME as CATEGORY,
                           AUCTIONITEMSUBCATEGORY.NAME as SUBCATEGORY,
                           AUCTIONITEM.TRANSACTIONVALUE,
                           AUCTIONITEM.TRANSACTIONMINIMUMBID,
                           REVENUE.DATE as DONATIONDATE,
                           AUCTIONITEM.EXPIRATIONDATE,
                           dbo.UFN_CONSTITUENT_BUILDNAME(REVENUE.CONSTITUENTID) as DONOR,
                           PACKAGE.NAME as PACKAGE,
                           AUCTION.NAME as AUCTION,
                           DESIGNATION.NAME as DESIGNATION,
                           AUCTIONITEM.COPIEDFROMID,
                           case when REVENUEPOSTED.ID is null then 0 else 1 end as ISPOSTED,
                           AUCTIONITEM.TRANSACTIONCURRENCYID,
                           case
                           when AUCTIONITEMREVENUEPURCHASE.REVENUEPURCHASEID is null then 0 
                     else 1
                           end as [WASSOLD],
                           case
                           when AUCTIONITEM.TYPECODE = 0 and AUCTIONITEM.PACKAGEID is null and AUCTIONITEMRESERVATION.ID is null then 0
                           when AUCTIONITEM.TYPECODE = 0 and AUCTIONITEM.PACKAGEID is not null and [RESERVEDPACKAGEITEM].ID is null then 0
                           when AUCTIONITEM.TYPECODE = 1 and AUCTIONITEMRESERVATION.ID is null then 0
                     else 1
                           end as ISRESERVED
                    from dbo.AUCTIONITEM
                    left join dbo.AUCTIONITEMCATEGORY
                        on AUCTIONITEM.AUCTIONITEMCATEGORYID = AUCTIONITEMCATEGORY.ID
                    left join dbo.AUCTIONITEMSUBCATEGORY
                        on AUCTIONITEM.AUCTIONITEMSUBCATEGORYID = AUCTIONITEMSUBCATEGORY.ID
                    left join dbo.AUCTIONITEM as PACKAGE
                        on AUCTIONITEM.PACKAGEID = PACKAGE.ID
                    inner join dbo.REVENUE
                        on AUCTIONITEM.REVENUEAUCTIONDONATIONID = REVENUE.ID
                    inner join dbo.REVENUESPLIT
                        on AUCTIONITEM.REVENUEAUCTIONDONATIONID = REVENUESPLIT.REVENUEID
                    left join dbo.REVENUEPOSTED 
                        on REVENUE.ID = REVENUEPOSTED.ID
                    inner join dbo.DESIGNATION
                        on REVENUESPLIT.DESIGNATIONID = DESIGNATION.ID
                    left join dbo.EVENT as AUCTION
                        on AUCTIONITEM.EVENTAUCTIONID = AUCTION.ID
                    left join dbo.AUCTIONITEMREVENUEPURCHASE
                        on AUCTIONITEM.ID = AUCTIONITEMREVENUEPURCHASE.AUCTIONITEMID
                    left join dbo.AUCTIONITEMRESERVATION
                        on AUCTIONITEMRESERVATION.AUCTIONITEMID = AUCTIONITEM.ID
                    left join dbo.AUCTIONITEMRESERVATION [RESERVEDPACKAGEITEM]
                        on [RESERVEDPACKAGEITEM].AUCTIONITEMID = AUCTIONITEM.PACKAGEID
                    where (AUCTIONITEM.ID = @CONTEXTID or AUCTIONITEM.COPIEDFROMID = @CONTEXTID)
                    order by AUCTIONITEM.DATEADDED asc