publisherKey and datasetKey

uk1.sql

select 
  p.key as publisherKey, p.title, d.key as datasetKey, d.title, replace(replace(e.url, 'http://registry.als.scot/GBIF/', ''), '.zip', '') as guid
from
  dataset d JOIN 
  dataset_endpoint de ON d.key=de.dataset_key JOIN 
  endpoint e ON e.key=de.endpoint_key JOIN 
  organization p ON d.publishing_organization_key = p.key 
where 
  e.url like 'http://registry.als.scot/GBIF/%' 
order by p.title, d.title