-- _plots_19_count_of_censuses_per_plot_in_each_project

 SELECT project.projectname AS project_name, 

    plot.authorlocationcode AS plot_code, 

    count(*) AS inventories

   FROM ((plot plot(location_id)

   JOIN locationevent USING (location_id))

   LEFT JOIN project USING (project_id))

  WHERE (plot.source_id = ( SELECT source_by_shortname(:datasource::text) AS source_by_shortname))

  GROUP BY project.projectname, plot.authorlocationcode

  ORDER BY project.projectname, plot.authorlocationcode;