SELECT s."*Name_matched.batch", 

    s."concatenatedScientificName", 

    s."matchedTaxonName", 

    s."matchedTaxonRank", 

    s."*Name_matched.Name_score", 

    s."matchedScientificNameAuthorship", 

    s."matchedScientificNameID", 

    s."*Name_matched.Author_score", 

    s."matchedFamilyConfidence_fraction", 

    s."matchedFamily", 

    s."matchedGenus", 

    s."matchedGenusConfidence_fraction", 

    s."matchedSpecificEpithet", 

    s."matchedSpeciesConfidence_fraction", 

    s."matchedInfraspecificEpithet", 

    s."*Name_matched.Infraspecific_epithet_score", 

    s."identificationQualifier", 

    s."morphospeciesSuffix", 

    s."taxonomicStatus", 

    s.accepted_taxon_name_no_author, 

    s.accepted_author, 

    s.accepted_taxon_rank, 

    s."acceptedScientificNameID", 

    s.accepted_species_binomial, 

    s.accepted_family, 

    s."*Name_matched.Selected", 

    s."*Name_matched.Source", 

    s."*Name_matched.Warnings", 

    s."*Name_matched.Accepted_name_lsid", 

    s.taxon_scrub__is_valid_match, 

    s.scrubbed_unique_taxon_name, 

   FROM ( SELECT tnrs.batch AS "*Name_matched.batch", 

            tnrs."Name_submitted" AS "concatenatedScientificName", 

            tnrs."Name_matched" AS "matchedTaxonName", 

            tnrs."Name_matched_rank" AS "matchedTaxonRank", 

            tnrs."Name_score" AS "*Name_matched.Name_score", 

            tnrs."Name_matched_author" AS "matchedScientificNameAuthorship", 

            tnrs."Name_matched_url" AS "matchedScientificNameID", 

            tnrs."Author_score" AS "*Name_matched.Author_score", 

            tnrs."Family_score" AS "matchedFamilyConfidence_fraction", 

            COALESCE(tnrs."Name_matched_accepted_family", tnrs."Accepted_name_family") AS "matchedFamily", 

            tnrs."Genus_matched" AS "matchedGenus", 

            tnrs."Genus_score" AS "matchedGenusConfidence_fraction", 

            tnrs."Specific_epithet_matched" AS "matchedSpecificEpithet", 

            tnrs."Specific_epithet_score" AS "matchedSpeciesConfidence_fraction", 

            tnrs."Infraspecific_epithet_matched" AS "matchedInfraspecificEpithet", 

            tnrs."Infraspecific_epithet_score" AS "*Name_matched.Infraspecific_epithet_score", 

            tnrs."Annotations" AS "identificationQualifier", 

            tnrs."Unmatched_terms" AS "morphospeciesSuffix", 

            map_taxonomic_status(tnrs."Taxonomic_status", tnrs."Accepted_name") AS "taxonomicStatus", 

            tnrs."Accepted_name" AS accepted_taxon_name_no_author, 

            tnrs."Accepted_name_author" AS accepted_author, 

            tnrs."Accepted_name_rank" AS accepted_taxon_rank, 

            tnrs."Accepted_name_url" AS "acceptedScientificNameID", 

            tnrs."Accepted_name_species" AS accepted_species_binomial, 

            tnrs."Accepted_name_family" AS accepted_family, 

            tnrs."Selected" AS "*Name_matched.Selected", 

            tnrs."Source" AS "*Name_matched.Source", 

            tnrs."Warnings" AS "*Name_matched.Warnings", 

            tnrs."Accepted_name_lsid" AS "*Name_matched.Accepted_name_lsid", 

            tnrs.is_valid_match AS taxon_scrub__is_valid_match, 

 SELECT "MatchedTaxon"."*Name_matched.batch", 

    "MatchedTaxon"."concatenatedScientificName", 

    "MatchedTaxon"."matchedTaxonName", 

    "MatchedTaxon"."matchedTaxonRank", 

    "MatchedTaxon"."*Name_matched.Name_score", 

    "MatchedTaxon"."matchedScientificNameAuthorship", 

    "MatchedTaxon"."matchedScientificNameID", 

    "MatchedTaxon"."*Name_matched.Author_score", 

    "MatchedTaxon"."matchedFamilyConfidence_fraction", 

    "MatchedTaxon"."matchedFamily", 

    "MatchedTaxon"."matchedGenus", 

    "MatchedTaxon"."matchedGenusConfidence_fraction", 

    "MatchedTaxon"."matchedSpecificEpithet", 

    "MatchedTaxon"."matchedSpeciesConfidence_fraction", 

    "MatchedTaxon"."matchedInfraspecificEpithet", 

    "MatchedTaxon"."*Name_matched.Infraspecific_epithet_score", 

    "MatchedTaxon"."identificationQualifier", 

    "MatchedTaxon"."morphospeciesSuffix", 

    "MatchedTaxon"."taxonomicStatus", 

    "MatchedTaxon".accepted_taxon_name_no_author, 

    "MatchedTaxon".accepted_author, 

    "MatchedTaxon".accepted_taxon_rank, 

    "MatchedTaxon"."acceptedScientificNameID", 

    "MatchedTaxon".accepted_species_binomial, 

    "MatchedTaxon".accepted_family, 

    "MatchedTaxon"."*Name_matched.Selected", 

    "MatchedTaxon"."*Name_matched.Source", 

    "MatchedTaxon"."*Name_matched.Warnings", 

    "MatchedTaxon"."*Name_matched.Accepted_name_lsid", 

    "MatchedTaxon".taxon_scrub__is_valid_match, 

    "MatchedTaxon".scrubbed_unique_taxon_name, 

 SELECT tnrs."Name_submitted" AS scrubbed_unique_taxon_name, 

    tnrs."Name_matched_rank" AS scrubbed_taxon_rank, 

    COALESCE(tnrs."Name_matched_accepted_family", tnrs."Family_matched") AS scrubbed_family, 

    tnrs."Genus_matched" AS scrubbed_genus, 

    tnrs."Specific_epithet_matched" AS scrubbed_specific_epithet, 

    tnrs."Infraspecific_rank" AS scrubbed_infraspecific_rank, 

    tnrs."Infraspecific_epithet_matched" AS scrubbed_infraspecific_epithet, 

    tnrs."Name_matched_author" AS scrubbed_author, 

    tnrs."Name_matched" AS scrubbed_taxon_name_no_author, 

 SELECT "ValidMatchedTaxon".scrubbed_unique_taxon_name, 

    "ValidMatchedTaxon"."*Name_matched.batch", 

    "ValidMatchedTaxon"."concatenatedScientificName", 

    "ValidMatchedTaxon"."matchedTaxonName", 

    "ValidMatchedTaxon"."matchedTaxonRank", 

    "ValidMatchedTaxon"."*Name_matched.Name_score", 

    "ValidMatchedTaxon"."matchedScientificNameAuthorship", 

    "ValidMatchedTaxon"."matchedScientificNameID", 

    "ValidMatchedTaxon"."*Name_matched.Author_score", 

    "ValidMatchedTaxon"."matchedFamilyConfidence_fraction", 

    "ValidMatchedTaxon"."matchedFamily", 

    "ValidMatchedTaxon"."matchedGenus", 

    "ValidMatchedTaxon"."matchedGenusConfidence_fraction", 

    "ValidMatchedTaxon"."matchedSpecificEpithet", 

    "ValidMatchedTaxon"."matchedSpeciesConfidence_fraction", 

    "ValidMatchedTaxon"."matchedInfraspecificEpithet", 

    "ValidMatchedTaxon"."*Name_matched.Infraspecific_epithet_score", 

    "ValidMatchedTaxon"."identificationQualifier", 

    "ValidMatchedTaxon"."morphospeciesSuffix", 

    "ValidMatchedTaxon"."taxonomicStatus", 

    "ValidMatchedTaxon".accepted_taxon_name_no_author, 

    "ValidMatchedTaxon".accepted_author, 

    "ValidMatchedTaxon".accepted_taxon_rank, 

    "ValidMatchedTaxon"."acceptedScientificNameID", 

    "ValidMatchedTaxon".accepted_species_binomial, 

    "ValidMatchedTaxon".accepted_family, 

    "ValidMatchedTaxon"."*Name_matched.Selected", 

    "ValidMatchedTaxon"."*Name_matched.Source", 

    "ValidMatchedTaxon"."*Name_matched.Warnings", 

    "ValidMatchedTaxon"."*Name_matched.Accepted_name_lsid", 

    "ValidMatchedTaxon".taxon_scrub__is_valid_match, 

    "ValidMatchedTaxon".accepted_morphospecies_binomial, 

    "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_taxon_rank, 

    "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_family, 

    "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_genus, 

    "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_specific_epithet, 

    "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_infraspecific_rank, 

    "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_infraspecific_epithet, 

    "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_author, 

    "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_taxon_name_no_author, 

    "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_taxon_name_with_author,