SELECT 
	data_resource.id, 
	CONCAT(citation,' (accessed through GBIF data portal, http://data.gbif.org/datasets/resource/',data_resource.id,' ',date(now())) AS citation_provided, 
CONCAT(data_provider.name, ', ',data_resource.name,' (accessed through GBIF data portal, http://data.gbif.org/datasets/resource/',data_resource.id, ', ',date(now())) AS citation_generated 
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/resource_citations.txt';