select FirstName, Lastname, Belt, Age, Sex, Instructor, PaymentMethod, PayStatus, DateCreated as RegistrationDate from register left join belt on register.belt = belt.name where eventname = '#request.event_code#' order by belt.sequence, Age, Sex asc

Divisions

Sorted by Belt, Age, Sex

Belt Age Sex First Name Last Name Instructor
#Belt# #Age# #Sex# #FirstName# #LastName# #Instructor#