SELECT count(*) AS count

WHERE reference_id =

;

SELECT 'projects' AS ___;

SELECT projectname

FROM project

WHERE reference_id =

ORDER BY projectname

;

SELECT E'each project\'s # locations' AS ___;

SELECT projectname, count(*) AS locations_count

FROM project

JOIN locationevent USING (project_id)

WHERE project.reference_id =

GROUP BY projectname

;

SELECT '# top-level locations' AS ___;

SELECT count(DISTINCT location_id) AS count

FROM location

WHERE reference_id =

AND parent_id IS NULL -- no subplots

;

SELECT '# top-level location events' AS ___;

SELECT count(*) AS count

WHERE reference_id =

AND parent_id IS NULL -- no subplots

;

    projectname

    , method.name AS method

FROM project

JOIN locationevent USING (project_id)

JOIN method USING (method_id)

WHERE project.reference_id =

ORDER BY projectname, method

LIMIT 10;

SELECT '1st observation measures' AS ___;

SELECT DISTINCT

    projectname

    , method.observationmeasure AS observationmeasure

FROM project

JOIN locationevent USING (project_id)

JOIN method USING (method_id)

WHERE project.reference_id =

ORDER BY projectname, observationmeasure

LIMIT 10;