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