: SELECT MV162546.FNAME, MV162546.LNAME, MV162546.CITY, MV162546.STATE, MV162546.CLASSHOA, As BROKEHOA, As ShotHOA FROM MV162546 WHERE ( CLASSHOA <> "" AND MV162546.ENTRY = 2 ) ORDER By BROKEHOA DESC