neotoma
.ndb
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
stewardcontrib(startperiod integer DEFAULT 0, endperiod integer DEFAULT 1)
Parameters
Name
Type
Mode
startperiod
integer
IN
endperiod
integer
IN
databasename
character varying
TABLE
counts
bigint
TABLE
Definition
SELECT cdb.databasename, count(*) FROM ndb.datasets AS ds JOIN ndb.datasetsubmissions AS dss on dss.datasetid = ds.datasetid JOIN ndb.constituentdatabases AS cdb ON cdb.databaseid = dss.databaseid WHERE EXTRACT(year from AGE(NOW(), dss.submissiondate))*12 + EXTRACT(month from AGE(NOW(), dss.submissiondate)) BETWEEN startperiod and endperiod GROUP BY cdb.databasename