     i.id as identification_ref,
     c.people_ref
   FROM
-    identifications_abdc i
-    INNER JOIN catalogue_people c on i.old_identification_id = c.record_id AND c.referenced_relation='identifications'
-    INNER JOIN people p on p.id = c.people_ref
+    darwin2.identifications_abdc i
+    INNER JOIN darwin2.catalogue_people c on i.old_identification_id = c.record_id AND c.referenced_relation='identifications'
+    INNER JOIN darwin2.people p on p.id = c.people_ref
   WHERE
     p.is_physical = true
     

CREATE TABLE public.darwin_metadata AS
(
  SELECT
    'Rue Vautier straat, 29 - 1000 Bruxelles/Brussels - Belgique/Belgïe'::text as content_contact_address,
    'collections@naturalsciences.be'::text as content_contact_email,
    'RBINS contact'::text as content_contact_name,

  f.id as flat_id,
  tag as place
  
  FROM  darwin2.darwin_flat f
  
  inner join darwin2.tags ON f.gtu_ref = tags.gtu_ref

  WHERE sub_group_type != 'country'
);
