-- _plots_06a_list_of_stems

 SELECT project.projectname AS project_name, 

    plot.authorlocationcode AS plot_code, 

    stemobservation.sourceaccessioncode AS stem_id

   FROM ((((((plot

   JOIN locationevent USING (plot_id))

   LEFT JOIN project USING (project_id))

   JOIN taxonoccurrence USING (locationevent_id))

   JOIN aggregateoccurrence USING (taxonoccurrence_id))

   JOIN plantobservation USING (aggregateoccurrence_id))

   JOIN stemobservation USING (plantobservation_id))

  WHERE ((plot.source_id = ( SELECT source_by_shortname(:datasource::text) AS source_by_shortname)) AND ((stemobservation.sourceaccessioncode IS NOT NULL) OR (stemobservation.authorstemcode IS NOT NULL)))

  ORDER BY project.projectname, plot.authorlocationcode, stemobservation.sourceaccessioncode;

-- _plots_20_tnrs_input_names

 SELECT DISTINCT taxonlabel.taxonomicname AS tnrs_input_name

   FROM taxonlabel

  WHERE ((taxonlabel.source_id = ( SELECT source_by_shortname(:datasource::text) AS source_by_shortname)) AND (taxonlabel.taxonomicname IS NOT NULL));

-- _plots_21_tnrs_output_names

 SELECT DISTINCT taxon_scrub.scrubbed_taxon_name_no_author AS tnrs_output_name

   FROM (taxonlabel

   JOIN "TNRS".taxon_scrub ON ((taxon_scrub."concatenatedScientificName" = taxonlabel.taxonomicname)))

  WHERE ((taxonlabel.source_id = ( SELECT source_by_shortname(:datasource::text) AS source_by_shortname)) AND (taxon_scrub."concatenatedScientificName" IS NOT NULL));