SELECT d.id, d.short_name, d.date_created, d.date_updated,
       v.id, v.short_name, v.comment, v.date_created, v.date_updated,
       ps.description,
       df.id, df.date_created, df.date_updated, df.name,
       fap.id, fap.endpoint, fap.size
FROM metadata.dataset AS d
JOIN metadata.dataset_version AS v ON d.id = v.dataset_id
JOIN metadata.published_state AS ps ON v.published_state_id = ps.id
JOIN metadata.dataset_file AS df ON v.id = df.dataset_version_id
JOIN metadata.file_access_point fap ON df.id = fap.id
WHERE d.short_name = 'ucar.cgd.cesm2le.atm.proc.6hourly_ave.TMQ';
