Bookaroom - MYSQL - Meeting Attendance by Branch

SELECT
    COUNT( DISTINCT `ti`.`ti_id` ) as `eventCount`,
    SUM( `res`.`me_numAttend` ) as `attendance`,
    IF( `br`.`branchDesc` IS NULL, 'Unknown', `br`.`branchDesc` ) as `branch_description`,
`ti`.`ti_startTime`
FROM `{YOUR_DATABASE_NAME}`.`{YOUR_WP_PREFIX}bookaroom_times` as `ti`
LEFT JOIN `{YOUR_DATABASE_NAME}`.`{YOUR_WP_PREFIX}bookaroom_reservations` as `res` ON `ti`.`ti_extID` = `res`.`res_id`
LEFT JOIN `{YOUR_DATABASE_NAME}`.`{YOUR_WP_PREFIX}bookaroom_roomConts` as `rc` ON `ti`.`ti_roomID` = `rc`.`roomCont_ID`
LEFT JOIN `{YOUR_DATABASE_NAME}`.`{YOUR_WP_PREFIX}bookaroom_branches` as `br` ON ( IF( `rc`.`roomCont_branch` IS NULL or `rc`.`roomCont_branch` = '',
    `ti`.`ti_noLocation_branch`, `rc`.`roomCont_branch` ) ) = `br`.`branchID`
WHERE `ti`.`ti_type` = 'meeting' AND `res`.`me_status` = 'approved'
GROUP BY `branch_description`