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