SELECT
--   users.id, SUM(orders.advertiser_expected_payout - orders.affiliate_payout -  affiliate_ref_payout)
      SUM(orders.advertiser_expected_payout - orders.affiliate_payout -  affiliate_ref_payout)
FROM
  orders
LEFT JOIN
  offers_advertiser_offers
ON
  (orders.advertiser_offer_id = offers_advertiser_offers.id)
LEFT JOIN
  users
ON
  (orders.user_id = users.id)
LEFT JOIN
  users_reg_data
ON
  users.reg_data_id = users_reg_data.id
WHERE
  DATE_ADD(users.registered_at, INTERVAL 3 HOUR) >= "2019-03-01 00:00:00"
AND
  DATE_ADD(users.registered_at, INTERVAL 3 HOUR)  < "2019-04-01 00:00:00"
AND
  DATE_ADD(orders.created_at, INTERVAL 3 HOUR) >= "2019-03-01 00:00:00"
 AND
   DATE_ADD(orders.created_at, INTERVAL 3 HOUR)  < "2019-04-01 00:00:00"
 AND
  orders.advertiser_payout_currency = "RUB"
AND
  orders.affiliate_payout_currency = "RUB"
AND
  orders.real_status = 10
AND
  post_id is Null
AND
  offers_advertiser_offers.advertiser_id <> 12641
-- orders.advertiser_expected_payout - orders.affiliate_payout -  affiliate_ref_payout >= 0
AND
  users.is_cpa_network = 0
 AND
  users_reg_data.utm_source is not Null
 AND
  users_reg_data.utm_source <> 'landings'
 AND
  users_reg_data.utm_source <> ''
-- GROUP BY
--   user_id
-- INTO OUTFILE '/tmp/data1.txt'
-- FIELDS TERMINATED BY ','
-- LINES TERMINATED BY '\n'
;