Here's the output from that item:
SELECT SQL_CALC_FOUND_ROWS DISTINCT `staff_certifications`.`id` AS `staff_certifications___id`,
`staff_certifications`.`id` AS `staff_certifications___id_raw`,
`staff_certifications`.`date_time` AS `staff_certifications___date_time`,
`staff_certifications`.`date_time` AS `staff_certifications___date_time_raw`,
`staff_certifications`.`modified_by` AS `staff_certifications___modified_by_raw`,
`joslo_users`.`name` AS `staff_certifications___modified_by`,
`staff_certifications`.`name` AS `staff_certifications___name`,
`staff_certifications`.`name` AS `staff_certifications___name_raw`,
`staff_certifications`.`center` AS `staff_certifications___center`,
`staff_certifications`.`center` AS `staff_certifications___center_raw`,
`staff_certifications`.`degree` AS `staff_certifications___degree`,
`staff_certifications`.`degree` AS `staff_certifications___degree_raw`,
`staff_certifications`.`inservice_training_hours` AS `staff_certifications___inservice_training_hours`,
`staff_certifications`.`inservice_training_hours` AS `staff_certifications___inservice_training_hours_raw`,
`staff_certifications`.`cda` AS `staff_certifications___cda`,
`staff_certifications`.`cda` AS `staff_certifications___cda_raw`,
`staff_certifications`.`child_abuse_neglect` AS `staff_certifications___child_abuse_neglect`,
`staff_certifications`.`child_abuse_neglect` AS `staff_certifications___child_abuse_neglect_raw`,
`staff_certifications`.`cr` AS `staff_certifications___cr`,
`staff_certifications`.`cr` AS `staff_certifications___cr_raw`,
`staff_certifications`.`cpr` AS `staff_certifications___cpr`,
`staff_certifications`.`cpr` AS `staff_certifications___cpr_raw`,
`staff_certifications`.`fp` AS `staff_certifications___fp`,
`staff_certifications`.`fp` AS `staff_certifications___fp_raw`,
`staff_certifications`.`first_aid` AS `staff_certifications___first_aid`,
`staff_certifications`.`first_aid` AS `staff_certifications___first_aid_raw`,
`staff_certifications`.`safe_sleep` AS `staff_certifications___safe_sleep`,
`staff_certifications`.`safe_sleep` AS `staff_certifications___safe_sleep_raw`,
`staff_certifications`.`tb` AS `staff_certifications___tb`,
`staff_certifications`.`tb` AS `staff_certifications___tb_raw`,
`staff_certifications`.`unip` AS `staff_certifications___unip`,
`staff_certifications`.`unip` AS `staff_certifications___unip_raw`,
`staff_certifications`.`race` AS `staff_certifications___race`,
`staff_certifications`.`race` AS `staff_certifications___race_raw`,
`staff_certifications`.`id` AS slug
, `staff_certifications`.`id` AS `__pk_val`
FROM `staff_certifications`
LEFT JOIN `#__users` AS `joslo_users` ON `joslo_users`.`id` = `staff_certifications`.`modified_by`
WHERE ( (CONVERT_TZ(staff_certifications.unip, "+0:00", "+00:00") >= DATE_ADD(LAST_DAY(now()), INTERVAL 1 DAY) AND CONVERT_TZ(staff_certifications.unip, "+0:00", "+00:00") <= DATE_ADD(LAST_DAY(NOW()), INTERVAL 1 MONTH) ) OR (CONVERT_TZ(staff_certifications.unip, "+0:00", "+00:00") >= DATE_ADD(LAST_DAY(DATE_SUB(now(), INTERVAL 2 MONTH)), INTERVAL 1 DAY) AND CONVERT_TZ(staff_certifications.unip, "+0:00", "+00:00") <= LAST_DAY(DATE_SUB(NOW(), INTERVAL 1 MONTH)) ) OR (CONVERT_TZ(staff_certifications.unip, "+0:00", "+00:00") >= DATE_ADD(LAST_DAY(DATE_SUB(now(), INTERVAL 1 MONTH)), INTERVAL 1 DAY) AND CONVERT_TZ(staff_certifications.unip, "+0:00", "+00:00") <= LAST_DAY(NOW()) ) ) AND ( `staff_certifications`.`unip` BETWEEN '2018-09-17 05:00:00' AND '2018-09-16 17:59:59' )
ORDER BY `staff_certifications`.`unip` ASC,`staff_certifications`.`center` ASC,`staff_certifications`.`center` ASC