Project

General

Profile

« Previous | Next » 

Revision 12645

Added by Aaron Marcuse-Kubitza almost 11 years ago

fix: validation/aggregating/plots/bien3_validations_salvias_vegbien.sql: removed `public.` qualifier

View differences:

trunk/validation/aggregating/plots/bien3_validations_salvias_vegbien.sql
80 80 
-- _plots_07_list_of_plots_which_use_counts_of_indiv_per_species
81 81 
 SELECT project.projectname AS project_name,
82 82 
    plot.authorlocationcode AS plot_code
83 
   FROM ((public.plot
84 
   JOIN public.locationevent USING (plot_id))
85 
   LEFT JOIN public.project USING (project_id))
86 
  WHERE ((plot.source_id = ( SELECT public.source_by_shortname(:datasource::text) AS source_by_shortname)) AND (EXISTS ( SELECT NULL::unknown AS unknown
87 
   FROM (((public.location
88 
   JOIN public.locationevent locationevent_1 USING (location_id))
89 
   JOIN public.taxonoccurrence USING (locationevent_id))
90 
   JOIN public.aggregateoccurrence USING (taxonoccurrence_id))
83 
   FROM ((plot
84 
   JOIN locationevent USING (plot_id))
85 
   LEFT JOIN project USING (project_id))
86 
  WHERE ((plot.source_id = ( SELECT source_by_shortname(:datasource::text) AS source_by_shortname)) AND (EXISTS ( SELECT NULL::unknown AS unknown
87 
   FROM (((location
88 
   JOIN locationevent locationevent_1 USING (location_id))
89 
   JOIN taxonoccurrence USING (locationevent_id))
90 
   JOIN aggregateoccurrence USING (taxonoccurrence_id))
91 91 
  WHERE ((location.plot_location_id = plot.plot_id) AND (aggregateoccurrence.count > 1))
92 92 
 LIMIT 1)))
93 93 
  ORDER BY plot.authorlocationcode;

Also available in: Unified diff