Change the LEFT JOIN to a JOIN in the location_ma table so that we don't return rows with the facility id as NULL.