SELECT 'collection codes' AS ___;

SELECT DISTINCT collectioncode_dwc

FROM specimenreplicate

WHERE datasource_id =

    (SELECT party_id FROM party WHERE organizationname = :datasource)

;

SELECT '# catalog numbers' AS ___;

SELECT count(DISTINCT catalognumber_dwc) AS count

FROM specimenreplicate

WHERE datasource_id =

    (SELECT party_id FROM party WHERE organizationname = :datasource)

;