Project

General

Profile

« Previous | Next » 

Revision 12411

Added by Aaron Marcuse-Kubitza almost 11 years ago

fix: schemas/vegbien.sql: _plots_03_count_of_all_plots_in_this_source: use top_plot instead of location because the corresponding input query includes just the top-level plots

View differences:

trunk/schemas/vegbien.sql
5876 5876 

  		




  5877
  5877
  
    
CREATE VIEW _plots_03_count_of_all_plots_in_this_source AS


  		




  5878
  5878
  
    
 SELECT count(*) AS plots


  		




  5879
  
  
    
   FROM (((public.location l


  		




  
  5879
  
    
   FROM (((public.top_plot l


  		




  5880
  5880
  
    
   JOIN public.locationevent le ON ((l.location_id = le.location_id)))


  		




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


  		




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


  		












Also available in:  Unified diff