ORDER BY BOG_Committee_Report_Member_Order__c, BOG_Committee_Report_ORG_Order__c, Contact__r.LastName

ORDER BY BOG_Membership__r.BOG_Committee_Report_Member_Order__c, BOG_Membership__r.BOG_Committee_Report_ORG_Order__c, BOG_Membership__r.Contact__r.LastName

SELECT BOG_Committee__r.Name, BOG_Committee__r.Official_1__r.Name, BOG_Committee__r.Role_1__c,BOG_Committee__r.Official_2__r.Name, BOG_Committee__r.Role_2__c,BOG_Committee__r.Official_3__r.Name, BOG_Committee__r.Role_3__c, Member_Type__c, BOG_Membership__r.ORG__c,  Executive_Membership_Type__c, BOG_Membership__r.Contact_Name__c, BOG_Membership__r.BOG_Committee_Report_Member_Order__c, BOG_Membership__r.BOG_Committee_Report_ORG_Order__c, BOG_Membership__r.Contact__r.LastName
                                                                FROM BOG_Committee_w_Membership__c
                                                                WHERE BOG_Committee__r.Name = : committeeName
                                                                AND BOG_Membership__r.BOG_Membership_Status__c = : memStatus
                                                                AND End_Date__c = Null
                                                                AND BOG_Membership__r.RecordTypeID = : rcrdTypeId
                                                                ORDER BY BOG_Membership__r.BOG_Committee_Report_Member_Order__c, BOG_Membership__r.BOG_Committee_Report_ORG_Order__c, BOG_Membership__r.Contact__r.LastName