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