-- ES Tienen entrenamientos
  INSERT INTO weekly_impact_calculations
       (athlete_id, date_snap, year_snap, week_of_year_snap, date_from, date_until,
 first_name, utc_time, language, language_es, has_selected_cause,
 has_impact,
 has_pending_donations,
 has_goal, progress,
 workouts, workouts_text,
 donated_calories, donated_calories_text,
 steps, steps_text,
 donation_title, -- "Donaciones / Donations"
 donations_value, donations_value_text,
  points_earned, points_earned_text,
 used_points, used_points_text,
 available_points, available_points_text)


--          workouts, calories, meals, meals_real, workouts_text, calories_text, meals_text)

--    SELECT t.athlete_id, _date_snap, _year_snap, _week_of_year_snap, _date_from, _date_until,
SELECT a.id, now(), 2019, 45, (now() - interval '1 week')::date, now()::date,
-- SELECT a.id,
            u.first_name, a.utc_time, a.language, CASE WHEN a.language = 'es' OR a.language IS NULL THEN 1 ELSE 0 END, 1,
            CASE WHEN COUNT(v.id) > 0 THEN 1 ELSE 0 END,
            CASE WHEN COUNT(v.id) > COUNT(v.donation_id) THEN 1 ELSE 0 END,
            CASE WHEN mma.goal > 0 THEN 1 ELSE 0 END, mma.advance_percentage,
            COUNT(v.training_start_date), to_char(COUNT(v.training_start_date),'99999999'),
            SUM(d.donated_calories), to_char(SUM(d.donated_calories),'99999999'),
            SUM(v.steps_steps), to_char(SUM(steps_steps),'99999999'),
            CASE WHEN a.language = 'es' OR a.language IS NULL THEN 'Donaciones' ELSE 'Donations' END,
            SUM(d.donated_value), to_char(SUM(d.donated_value),'99999999'),
            SUM(CASE WHEN p.btg_points > 0 THEN p.btg_points ELSE 0 END), to_char(SUM(CASE WHEN p.btg_points > 0 THEN p.btg_points ELSE 0 END),'99999999'),
            SUM(CASE WHEN p.btg_points < 0 THEN p.btg_points ELSE 0 END), to_char(SUM(CASE WHEN p.btg_points < 0 THEN p.btg_points ELSE 0 END),'99999999'),
            a.available_btg_points, to_char(a.available_btg_points,'99999999')
  FROM view_materialized_activities_all v
    INNER JOIN burn_to_give_athlete a ON (v.athlete_id = a.id)
    INNER JOIN auth_user u ON (a.user_id = u.id)
    LEFT JOIN burn_to_give_metricsmonthathlete mma ON (v.athlete_id = mma.athlete_id)
    LEFT JOIN burn_to_give_donation d ON (v.donation_id = d.id)
    LEFT JOIN burn_to_give_btgpoints p ON (v.athlete_id = p.athlete_id)
    --LEFT JOIN burn_to_give_athletebycampaign abc (a.id = abc.id)
 WHERE a.id = 236 AND
 v.date BETWEEN now() - interval '1 month' AND now()
 AND p.date BETWEEN now() - interval '1 month' AND now()
 AND EXTRACT(YEAR FROM mma.date) = EXTRACT(YEAR FROM now()) AND EXTRACT(MONTH FROM mma.date) = EXTRACT(MONTH FROM now())
 AND mma.advance_percentage > 0 -- BORRAR ESTO ES DE PRUEBAAAA
GROUP BY  a.id, u.first_name, a.utc_time, a.language, mma.goal, mma.advance_percentage