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