Please respect the rights declared for each dataset in the download: SELECT CONCAT('Dataset: ',data_resource.name,', http://data.gbif.org/datasets/resource/',data_resource.id), IF(ISNULL(rights) OR length(rights)=0, 'GBIF Data Sharing Agreement is applied. GBIF Data Use Agreement is applied.', CONCAT('Rights as supplied: ',rights)) FROM data_resource JOIN data_provider ON data_resource.data_provider_id = data_provider.id WHERE data_resource.deleted IS NULL AND data_provider.id > 3 INTO OUTFILE '/var/local/large/db/mysql/rights.txt';