SELECT project.projectname AS project_name, 

    plot.authorlocationcode AS plot_code

   FROM ((public.plot

   JOIN public.locationevent USING (plot_id))

   LEFT JOIN public.project USING (project_id))

  WHERE ((plot.source_id = ( SELECT public.source_by_shortname(:datasource::text) AS source_by_shortname)) AND (EXISTS ( SELECT NULL::unknown AS unknown

   FROM (((public.location

   JOIN public.locationevent locationevent_1 USING (location_id))

   JOIN public.taxonoccurrence USING (locationevent_id))

   JOIN public.aggregateoccurrence USING (taxonoccurrence_id))

  WHERE ((location.plot_location_id = plot.plot_id) AND (aggregateoccurrence.count > 1))

 LIMIT 1)))

  ORDER BY plot.authorlocationcode;