Finally... was able to do it. Here is the updated working query, in case anyone needs it:
select distinct
CASE prefix_facetoface_signups_status.statuscode
WHEN 10 THEN 'User Cancelled'
WHEN 20 THEN 'Session Cancelled'
WHEN 30 THEN 'Declined'
WHEN 40 THEN 'Requested'
WHEN 50 THEN 'Approved'
WHEN 60 THEN 'Waitlisted'
WHEN 70 THEN 'Booked'
WHEN 80 THEN 'No Show'
WHEN 90 THEN 'Partially Attended'
WHEN 100 THEN 'Fully Attended'
END as Status,
prefix_facetoface.name as 'Facetoface Name',
concat(prefix_user.firstname, ' ', prefix_user.lastname) AS Name,
prefix_user.username as Username,
prefix_user.email as Email,
DATE_FORMAT( FROM_UNIXTIME( IF( prefix_facetoface_sessions_dates.timestart <=> 0, NULL,
prefix_facetoface_sessions_dates.timestart)), '%M %d, %Y' ) AS StartDate,
DATE_FORMAT( FROM_UNIXTIME( IF( prefix_facetoface_sessions_dates.timefinish<=> 0, NULL,
prefix_facetoface_sessions_dates.timefinish)), '%M %d, %Y' ) AS FinishDate
from prefix_facetoface_signups
inner join prefix_facetoface_signups_status
on prefix_facetoface_signups.id = prefix_facetoface_signups_status.signupid
inner join prefix_user
on prefix_facetoface_signups.userid = prefix_user.id
inner join prefix_facetoface_sessions_dates
on prefix_facetoface_signups.sessionid = prefix_facetoface_sessions_dates.sessionid
inner join prefix_facetoface_sessions
on prefix_facetoface_signups.sessionid = prefix_facetoface_sessions.id
inner join prefix_facetoface
on prefix_facetoface.id = prefix_facetoface_sessions.facetoface
order by finishdate desc