Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --*** Gives Duplications for some reason ***
- SELECT outer_e.hours, outer_e.id, outer_e.updated_at, outer_e.spent_date, u.first_name, u.is_active, u.id AS user_id, u.weekly_capacity FROM
- (SELECT e.id, MAX(e.updated_at) AS updated_at FROM `harvest-experiment.harvest.time_entries` AS e
- GROUP BY e.id LIMIT 1000) AS inner_e
- LEFT JOIN `harvest-experiment.harvest.time_entries` AS outer_e
- ON inner_e.id = outer_e.id AND inner_e.updated_at = outer_e.updated_at
- LEFT JOIN `harvest-experiment.harvest.users` AS u
- ON outer_e.user_id = u.id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement