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