a guest Jun 26th, 2019 56 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. --*** Gives Duplications for some reason ***
  2. SELECT outer_e.hours,, outer_e.updated_at, outer_e.spent_date, u.first_name, u.is_active, AS user_id, u.weekly_capacity FROM
  3.   (SELECT, MAX(e.updated_at) AS updated_at FROM `harvest-experiment.harvest.time_entries` AS e
  4.   GROUP BY LIMIT 1000) AS inner_e
  5. LEFT JOIN `harvest-experiment.harvest.time_entries` AS outer_e
  6. ON = AND inner_e.updated_at = outer_e.updated_at
  7. LEFT JOIN `harvest-experiment.harvest.users` AS u
  8. ON outer_e.user_id =
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand