select 
  tbl_sites.site_id as "site_id", 
  site_name as "Site name", 
  site_description as "Site description", 
  natgridref as "National grid ref", 
  array_to_string(
    array_agg(
      location_name 
      order by 
        location_type_id desc
    ), 
    ','
  ) as Places, 
  preservation_status_or_threat as "Preservation status or sthreat", 
  latitude_dd as site_lat, 
  longitude_dd as site_lng 
From 
  tbl_sites 
  left join tbl_site_locations on tbl_site_locations.site_id = tbl_sites.site_id 
  left join tbl_site_natgridrefs on tbl_site_natgridrefs.site_id = tbl_sites.site_id 
  left join tbl_site_preservation_status on tbl_site_preservation_status.site_preservation_status_id = tbl_sites.site_preservation_status_id 
  left join tbl_locations on tbl_locations.location_id = tbl_site_locations.location_id 
where 
  1 = 1 
group by 
  tbl_sites.site_id, 
  site_name, 
  site_description, 
  natgridref, 
  site_lat, 
  site_lng, 
  preservation_status_or_threat