** Ongoing eBay Card Price update **
SELECT 
        name AS CardName, 
        SetName AS CardSetName, 
        CardVariation.id AS CardVariationID, 
        CardVariation.Finish AS Finish, 
        CurrentlySelling.id AS CurrentlySellingID, 
        LastUpdateDate, 
        eBayItemID, 
        USDPrice AS CardUSDPrice, 
        CardCount, 
        LastPriceUpdateDate, 
        Price, 
        OfferingDate 
    FROM CardVariation
    INNER JOIN CardInfo ON CardInfo.id = CardVariation.CardInfo_id
    INNER JOIN CurrentlySelling ON CardVariation.id = CurrentlySelling.CardVariation_id
    INNER JOIN GameSet ON GameSet.SetCode = CardInfo.set_code
    WHERE LastPriceUpdateDate < NOW() - INTERVAL 1 DAY
    ORDER BY LastPriceUpdateDate 
    LIMIT 50

Witch of the NightToday is 2026-04-18
<br>Price USD Base Card Value Updated Date: 2026-04-17 12:21:01
<br>eBay Listing price updated date: 2026-04-17 07:52:02
<br>Card Name: Witch of the Night
<br>Set: The Moonlit Savior
<br>Card USD Value: 0.18
<br>eBayListingID: 186947298830
<br>eBay Listing Old Price: 0.99
<br>eBay Listing New Price: 0.99
<br>No price update required.  Same price.Price new revision log added

Lord Windgrace (Borderless)Today is 2026-04-18
<br>Price USD Base Card Value Updated Date: 2026-04-18 07:30:02
<br>eBay Listing price updated date: 2026-04-17 07:52:02
<br>Card Name: Lord Windgrace (Borderless)
<br>Set: Special Guests
<br>Card USD Value: 17.90
<br>eBayListingID: 187946137628
<br>eBay Listing Old Price: 29.16
<br>eBay Listing New Price: 29.16
<br>No price update required.  Same price.Price new revision log added

Clockwork Percussionist (0130)Today is 2026-04-18
<br>Price USD Base Card Value Updated Date: 2026-04-17 11:15:02
<br>eBay Listing price updated date: 2026-04-17 07:52:05
<br>Card Name: Clockwork Percussionist (0130)
<br>Set: Duskmourn: House of Horror
<br>Card USD Value: 0.26
<br>eBayListingID: 186700600336
<br>eBay Listing Old Price: 0.99
<br>eBay Listing New Price: 0.99
<br>No price update required.  Same price.Price new revision log added

Tristan, the Knight of SorrowToday is 2026-04-18
<br>Price USD Base Card Value Updated Date: 2026-04-17 12:21:01
<br>eBay Listing price updated date: 2026-04-17 07:52:05
<br>Card Name: Tristan, the Knight of Sorrow
<br>Set: The Moonlit Savior
<br>Card USD Value: 0.25
<br>eBayListingID: 186896396768
<br>eBay Listing Old Price: 0.99
<br>eBay Listing New Price: 0.99
<br>No price update required.  Same price.Price new revision log added

Demonic CommanderToday is 2026-04-18
<br>Price USD Base Card Value Updated Date: 2026-04-17 12:21:01
<br>eBay Listing price updated date: 2026-04-17 07:52:05
<br>Card Name: Demonic Commander
<br>Set: The Moonlit Savior
<br>Card USD Value: 0.25
<br>eBayListingID: 186896396769
<br>eBay Listing Old Price: 0.99
<br>eBay Listing New Price: 0.99
<br>No price update required.  Same price.Price new revision log added

Drill SergeantToday is 2026-04-18
<br>Price USD Base Card Value Updated Date: 2026-04-17 12:21:01
<br>eBay Listing price updated date: 2026-04-17 07:52:05
<br>Card Name: Drill Sergeant
<br>Set: The Moonlit Savior
<br>Card USD Value: 0.25
<br>eBayListingID: 186896396776
<br>eBay Listing Old Price: 0.99
<br>eBay Listing New Price: 0.99
<br>No price update required.  Same price.Price new revision log added

Unholy Heat (Borderless)Today is 2026-04-18
<br>Price USD Base Card Value Updated Date: 2026-04-18 07:30:02
<br>eBay Listing price updated date: 2026-04-17 07:52:05
<br>Card Name: Unholy Heat (Borderless)
<br>Set: Special Guests
<br>Card USD Value: 6.38
<br>eBayListingID: 187946137841
<br>eBay Listing Old Price: 12.09
<br>eBay Listing New Price: 10.94
<br>Success
eBay Listing updated.
INSERT INTO eBayPriceRevisionLog 
                (eBayItemID, CardVariation_id, CardName, LastUpdate, Status, AnswerMessage, OldPrice, NewPrice) 
                VALUES 
                ('187946137841','209357','Unholy Heat (Borderless)', NOW(), 'Success', '','12.09','10.94')Price revision log addedPrice new revision log added

Temple MonkToday is 2026-04-18
<br>Price USD Base Card Value Updated Date: 2026-04-17 12:21:01
<br>eBay Listing price updated date: 2026-04-17 07:52:09
<br>Card Name: Temple Monk
<br>Set: The Moonlit Savior
<br>Card USD Value: 0.15
<br>eBayListingID: 186905737883
<br>eBay Listing Old Price: 0.99
<br>eBay Listing New Price: 0.99
<br>No price update required.  Same price.Price new revision log added

Shiko, Paragon of the Way (Showcase)Today is 2026-04-18
<br>Price USD Base Card Value Updated Date: 2026-04-17 13:39:01
<br>eBay Listing price updated date: 2026-04-17 07:52:09
<br>Card Name: Shiko, Paragon of the Way (Showcase)
<br>Set: Tarkir: Dragonstorm
<br>Card USD Value: 8.13
<br>eBayListingID: 187926818442
<br>eBay Listing Old Price: 13.89
<br>eBay Listing New Price: 13.89
<br>No price update required.  Same price.Price new revision log added