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