SELECT
 self.id,
                self.status,
                self.channel,
                self.resume_file_name,
                self.source, self.name,
                self.firstname,
                self.patronymic,
                self.date,
                self.birthday,
                self.post_id,
                self.site_id,
                self.education1,
                self.education2,
                self.class_institution,
                self.hunter_score,
                self.experience_years,
                self.sex,
                self.email,
                self.vacancy_id,
                DATE_FORMAT(`hr_resume_log`.`date`, '%d.%m.%Y %H:%i') AS `date_status`,
         `post`.`name` AS `post_name`,
         `staff`.`name` AS `hunter_name`
FROM
 `vw_hr_candidate` AS `self`
  LEFT JOIN `hr_user_post` AS `post` ON self.post_id = post.id
  LEFT JOIN `lst_staff` AS `staff` ON self.hunter = staff.id
  LEFT JOIN `hr_resume_log` ON hr_resume_log.candidate_id = self.id AND hr_resume_log.new_status_id = self.status
WHERE
 (`self`.`status` = '1')
ORDER BY
 `self`.`date` desc
LIMIT 100 OFFSET 0