     m.name as mineral_name,
     f.mineral_ref as mineral_ref,
     m.classification as classification
-    FROM  identifications_abdc i
-    INNER JOIN darwin_flat  f on i.flat_id = f.id
-    INNER JOIN mineralogy m on f.mineral_ref = m.id
+    FROM  darwin2.identifications_abdc i
+    INNER JOIN darwin2.darwin_flat  f on i.flat_id = f.id
+    INNER JOIN darwin2.mineralogy m on f.mineral_ref = m.id
     WHERE i.is_current = true
       AND f.mineral_ref !=0 
       

  c.people_ref,
  c.order_by,
  p.formated_name
  FROM  darwin_flat  f
  inner join catalogue_people as c ON f.spec_ref = c.record_id  AND c.referenced_relation = 'specimens'
  INNER JOIN  people p ON p.id = c.people_ref and is_physical = true
  WHERE 
    c.people_type = 'collector'
  

    property_type  || ' / ' || property_sub_type as parameter

  FROM 
    darwin2.darwin_flat as flat
    INNER JOIN darwin2.catalogue_properties c ON referenced_relation = 'specimen_individuals' AND record_id = flat.individual_ref
    INNER JOIN darwin2.properties_values p ON property_ref = c.id 
  GROUP BY 
    flat.id,
    c.id,
