Project

General

Profile

« Previous | Next » 

Revision 12500

Added by Aaron Marcuse-Kubitza over 10 years ago

fix: schemas/vegbien.sql: _plots_04_count_of_plots_in_each_project_in_this_source: count top-level plots to match the input query

View differences:

vegbien.sql
6002 6002 
CREATE VIEW _plots_04_count_of_plots_in_each_project_in_this_source AS
6003 6003 
 SELECT p.projectname AS project_name,
6004 6004 
    count(DISTINCT l.location_id) AS plots
6005 
   FROM (((public.location l
6005 
   FROM (((public.top_plot l
6006 6006 
   JOIN public.locationevent le ON ((l.location_id = le.location_id)))
6007 6007 
   JOIN public.project p ON ((p.project_id = le.project_id)))
6008 6008 
   JOIN public.source s ON ((p.source_id = s.source_id)))

Also available in: Unified diff