neotoma
.ndb
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
datasetcontribs(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 ct.contactname, count(*) FROM ndb.datasets AS ds JOIN ndb.datasetsubmissions AS dss ON dss.datasetid = ds.datasetid JOIN ndb.contacts AS ct ON ct.contactid = dss.contactid WHERE EXTRACT(year from AGE(NOW(), dss.submissiondate))*12 + EXTRACT(month from AGE(NOW(), dss.submissiondate)) BETWEEN startperiod and endperiod GROUP BY ct.contactname