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