SELECT fish.genus, species, catalog_number, country, state, number_alch, number_skel, number_CS, type_status, field_number, size, determiner, county, collector, loc_date, locality, primary_remarks, loc_remarks, family, subspecies, cof_lookup, lat_dd, long_dd, latitude, longitude, fish.questionable, cont_ocean, waterbody, gear, depth, salinity FROM fish left join fish_family on fish.genus = fish_family.genus
where catalog_number = '47686'
order by genus, species, country, state, county