Project

General

Profile

« Previous | Next » 

Revision 6001

Added by Aaron Marcuse-Kubitza over 11 years ago

mappings/verify.plots.sql: Added # locations, # location events, which also include subplots

View differences:

verify.plots.sql
39 39 
AND parent_id IS NULL -- no subplots
40 40 
;
41 41 

  		




  
  42
  
    
SELECT '# locations' AS ___;


  		




  
  43
  
    
SELECT count(DISTINCT location_id) AS count


  		




  
  44
  
    
FROM location


  		




  
  45
  
    
WHERE reference_id =


  		




  
  46
  
    
    (SELECT reference_id FROM reference WHERE shortname = :datasource)


  		




  
  47
  
    
;


  		




  
  48
  
    

  		




  
  49
  
    
SELECT '# location events' AS ___;


  		




  
  50
  
    
SELECT count(*) AS count


  		




  
  51
  
    
FROM locationevent


  		




  
  52
  
    
WHERE reference_id =


  		




  
  53
  
    
    (SELECT reference_id FROM reference WHERE shortname = :datasource)


  		




  
  54
  
    
;


  		




  
  55
  
    

  		




  42
  56
  
    
SELECT '1st methods' AS ___;


  		




  43
  57
  
    
SELECT DISTINCT


  		




  44
  58
  
    
    projectname


  		












Also available in:  Unified diff