** Ongoing eBay Card Price update **

SELECT
    CardInfo.Name AS CardName,
    GameSet.SetName AS CardSetName,
    CardVariation.id AS CardVariationID,
    CardVariation.Finish AS Finish,
    CurrentlySelling.id AS CurrentlySellingID,
    CardVariation.LastUpdateDate,
    CurrentlySelling.eBayItemID,
    CardVariation.USDPrice AS CardUSDPrice,
    CurrentlySelling.CardCount,
    CurrentlySelling.LastPriceUpdateDate,
    CurrentlySelling.Price,
    CurrentlySelling.OfferingDate,
    CurrentlySelling.NeedPriceReviewDate
FROM CurrentlySelling
INNER JOIN CardVariation
    ON CardVariation.id = CurrentlySelling.CardVariation_id
INNER JOIN CardInfo
    ON CardInfo.id = CardVariation.CardInfo_id
INNER JOIN GameSet
    ON GameSet.SetCode = CardInfo.set_code
WHERE CurrentlySelling.NeedPriceReview = 1
ORDER BY
    CurrentlySelling.Price DESC
LIMIT 50