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