SELECT
                                    `intapps-old`.projekti_suradnk.id as suradnik_id,
                                  user_in_shift.`user_id`,
                                  `intapps-old`.cnf_user.ime,
                                  `intapps-old`.cnf_user.prezime,
                                  SUM(
                                  IF(user_in_shift.shift_end > user_in_shift.shift_start,
                                  HOUR(TIMEDIFF(user_in_shift.shift_end, user_in_shift.shift_start)),
                                  HOUR(ADDTIME(TIMEDIFF('24:00:00', user_in_shift.shift_start), user_in_shift.shift_end))) * wage
                                  ) AS honorar,
                                  COUNT(user_in_shift.`user_id`) AS broj_smjena,
                                  SUM( IF(user_in_shift.shift_end > user_in_shift.shift_start,
                                  HOUR(TIMEDIFF(user_in_shift.shift_end, user_in_shift.shift_start)),
                                  HOUR(ADDTIME(TIMEDIFF('24:00:00', user_in_shift.shift_start), user_in_shift.shift_end))))
                                  AS broj_sati
                                FROM user_in_shift
                                JOIN shift on shift.id = user_in_shift.`shift_id`
                                  LEFT OUTER JOIN users ON
                                    users.`id` = user_in_shift.`user_id`
                                  LEFT OUTER JOIN user_in_group ON
                                    users.`id` = user_in_group.`user_id`
                                  LEFT OUTER JOIN groups ON
                                    groups.`id` = user_in_group.`group_id`
                                  LEFT OUTER JOIN `intapps-old`.cnf_user ON
                                    `intapps-old`.cnf_user.user_id = user_in_shift.`user_id`
                                  LEFT OUTER JOIN `intapps-old`.projekti_suradnk ON
                                    `intapps-old`.projekti_suradnk.ldap_username = `intapps-old`.cnf_user.hrEduPersonUniqueID
                                WHERE
                                  MONTH(shift.date) = 2
                                  AND YEAR(shift.date) = 2018
                                  AND groups.`team` = 1
                                GROUP BY user_in_shift.`user_id`
                                ORDER BY `intapps-old`.cnf_user.prezime