** Ongoing eBay Card Price update **

SELECT
    ci.Name AS CardName,
    gs.SetName AS CardSetName,
    cv.id AS CardVariationID,
    cv.Finish AS Finish,
    cs.id AS CurrentlySellingID,
    cv.LastUpdateDate,
    cs.eBayItemID,
    cv.USDPrice AS CardUSDPrice,
    sv.LanguageCode,
    sv.ConditionCode,
    cs.LastPriceUpdateDate,
    cs.Price,
    cs.OfferingDate,
    cs.NeedPriceReviewDate
    , p.ProductType
FROM CurrentlySelling cs
INNER JOIN ProductContent pc
    ON pc.Product_id = cs.Product_id
INNER JOIN Product p
    ON p.id = pc.Product_id
INNER JOIN SellableVariant sv
    ON sv.id = pc.SellableVariant_id
INNER JOIN CardVariation cv
    ON cv.id = sv.CardVariation_id
INNER JOIN CardInfo ci
    ON ci.id = cv.CardInfo_id
INNER JOIN GameSet gs
    ON gs.SetCode = ci.set_code
   AND gs.GameCode = ci.GameCode
WHERE cs.NeedPriceReview = 1
ORDER BY
    cs.Price DESC
LIMIT 50