-- _plots_03_count_of_all_plots_in_this_source

 SELECT count(*) AS plots

   FROM (((plot l

   JOIN project p ON ((p.project_id = le.project_id)))

   JOIN source s ON ((p.source_id = s.source_id)))

  WHERE (s.shortname = :datasource::text);

-- _plots_04_count_of_plots_in_each_project_in_this_source

 SELECT p.projectname AS project_name, 

   FROM (((plot l

   JOIN project p ON ((p.project_id = le.project_id)))

   JOIN source s ON ((p.source_id = s.source_id)))

  WHERE (s.shortname = :datasource::text)

 SELECT p.projectname AS project_name, 

    l.authorlocationcode AS plot_code

   FROM (((plot l

   JOIN project p ON ((p.project_id = le.project_id)))

   JOIN source s ON ((p.source_id = s.source_id)))

  WHERE (s.shortname = :datasource::text);

 SELECT project.projectname AS project_name, 

    plot.authorlocationcode AS plot_code

   FROM ((plot

   LEFT JOIN project USING (project_id))

  WHERE ((plot.source_id = ( SELECT source_by_shortname(:datasource::text) AS source_by_shortname)) AND (EXISTS ( SELECT NULL::unknown AS unknown

   FROM (((((location

   JOIN aggregateoccurrence USING (taxonoccurrence_id))

   JOIN plantobservation USING (aggregateoccurrence_id))

   JOIN stemobservation USING (plantobservation_id))

 LIMIT 1)))

  ORDER BY plot.authorlocationcode;

   JOIN source s ON ((p.source_id = s.source_id)))

   JOIN place_visit ON ((p.project_id = place_visit.project_id)))

   JOIN locationevent le ON ((place_visit.locationevent_id = le.place_visit_id)))

   JOIN taxonoccurrence o ON ((le.locationevent_id = o.locationevent_id)))

   JOIN aggregateoccurrence ao ON ((o.taxonoccurrence_id = ao.taxonoccurrence_id)))

  WHERE (s.shortname = :datasource::text)

   JOIN source s ON ((p.source_id = s.source_id)))

   JOIN place_visit ON ((p.project_id = place_visit.project_id)))

   JOIN locationevent le ON ((place_visit.locationevent_id = le.place_visit_id)))

   JOIN taxonoccurrence o ON ((le.locationevent_id = o.locationevent_id)))

   JOIN aggregateoccurrence ao ON ((o.taxonoccurrence_id = ao.taxonoccurrence_id)))

  WHERE (s.shortname = :datasource::text)

   JOIN source s ON ((p.source_id = s.source_id)))

   JOIN locationevent le ON ((p.project_id = le.project_id)))

   JOIN locationevent sub_locationevent ON ((sub_locationevent.parent_id = le.locationevent_id)))

   JOIN taxonoccurrence o ON ((sub_locationevent.locationevent_id = o.locationevent_id)))

   JOIN aggregateoccurrence ao ON ((o.taxonoccurrence_id = ao.taxonoccurrence_id)))

   JOIN plantobservation po ON ((po.aggregateoccurrence_id = ao.aggregateoccurrence_id)))

   JOIN source s ON ((p.source_id = s.source_id)))

   JOIN locationevent le ON ((p.project_id = le.project_id)))

   JOIN locationevent sub_locationevent ON ((sub_locationevent.parent_id = le.locationevent_id)))

   JOIN taxonoccurrence o ON ((sub_locationevent.locationevent_id = o.locationevent_id)))

   JOIN taxondetermination td ON ((td.taxonoccurrence_id = o.taxonoccurrence_id)))

   JOIN taxonverbatim tv ON ((td.taxonverbatim_id = tv.taxonverbatim_id)))

   JOIN source s ON ((p.source_id = s.source_id)))

   JOIN locationevent le ON ((p.project_id = le.project_id)))

   JOIN locationevent sub_locationevent ON ((sub_locationevent.parent_id = le.locationevent_id)))

   JOIN taxonoccurrence o ON ((sub_locationevent.locationevent_id = o.locationevent_id)))

   JOIN taxondetermination td ON ((td.taxonoccurrence_id = o.taxonoccurrence_id)))

   JOIN taxonverbatim tv ON ((td.taxonverbatim_id = tv.taxonverbatim_id)))

   JOIN source s ON ((p.source_id = s.source_id)))

   JOIN locationevent le ON ((p.project_id = le.project_id)))

   JOIN locationevent sub_locationevent ON ((sub_locationevent.parent_id = le.locationevent_id)))

   JOIN taxonoccurrence o ON ((sub_locationevent.locationevent_id = o.locationevent_id)))

   JOIN taxondetermination td ON ((td.taxonoccurrence_id = o.taxonoccurrence_id)))

   JOIN taxonverbatim tv ON ((td.taxonverbatim_id = tv.taxonverbatim_id)))

   JOIN source s ON ((p.source_id = s.source_id)))

   JOIN locationevent le ON ((p.project_id = le.project_id)))

   JOIN locationevent sub_locationevent ON ((sub_locationevent.parent_id = le.locationevent_id)))

   JOIN taxonoccurrence o ON ((sub_locationevent.locationevent_id = o.locationevent_id)))

   JOIN taxondetermination td ON ((td.taxonoccurrence_id = o.taxonoccurrence_id)))

   JOIN taxonverbatim tv ON ((td.taxonverbatim_id = tv.taxonverbatim_id)))

   JOIN source s ON ((p.source_id = s.source_id)))

   JOIN locationevent le ON ((p.project_id = le.project_id)))

   JOIN locationevent sub_locationevent ON ((sub_locationevent.parent_id = le.locationevent_id)))

  WHERE (s.shortname = :datasource::text)

  GROUP BY p.projectname, l.authorlocationcode

  ORDER BY p.projectname, l.authorlocationcode;

   JOIN source s ON ((p.source_id = s.source_id)))

   JOIN locationevent le ON ((p.project_id = le.project_id)))

   JOIN locationevent sub_locationevent ON ((sub_locationevent.parent_id = le.locationevent_id)))

  WHERE (s.shortname = :datasource::text)

  ORDER BY p.projectname, l.authorlocationcode;

/*