Cacher is the code snippet organizer for pro developers

SELECT
  video_id
, title
, geo
, ROUND(SUM(main.amount * cur.to_usd), 2) sales_usd
, count(video_id) sales_qty

FROM
  (
    SELECT
      YEAR(date) * 100 + MONTH(date) month_id
    , amount
    , shown_amount
    , currency_id
    , geo
    , video_id
    , v.title
    , title_en
    , date
    , o.description
    FROM
      billing.orders o
        LEFT JOIN megogo2.service ms ON ms.service_id = o.service_id
        LEFT JOIN megogo2.video v ON v.obj_id = o.video_id

    WHERE ms.type not IN (1, 5)
    AND video_id IN (1956471, 1301471, 14391, 9237, 2365681)
    AND o.closed = '1'
--     and o.geo = 'UA'
--     and o.date >= '2016-11-02'
    AND o.type IN
    (
      SELECT
        type
      FROM
        daily.dict_pay_system m
      WHERE m.group = 'M'
    )
  ) main

    LEFT JOIN (
        SELECT
          currency_id
        , to_usd
        , YEAR(date) * 100 + MONTH(date) month_id
        FROM
          megogo_db.currency_daily
      ) cur ON cur.currency_id = main.currency_id
        AND main.month_id = cur.month_id
  GROUP BY video_id, title, geo