softwareheritage-deposit=> select distinct metadata->>'{http://www.w3.org/2005/Atom}title', metadata->>'{https://doi.org/10.5063/SCHEMA/CODEMETA-2.0}name', max(deposit_request.date) from deposit_request, deposit where deposit_request.deposit_id=deposit.id and raw_metadata is null and metadata is not null group by metadata->>'{http://www.w3.org/2005/Atom}title', metadata->>'{https://doi.org/10.5063/SCHEMA/CODEMETA-2.0}name'; ?column? | ?column? | max ---------------------------------------+-------------------------------------------------------------------------------------------------------------+------------------------------- | The assignment problem | 2018-06-27 06:55:08.607636+00 | Composing a Web of Audio Applications | 2018-06-27 06:55:13.838716+00 | AffectationRO- The assignment problem | 2018-02-26 16:56:12.295115+00 | Tableur | 2018-03-20 12:09:07.937099+00 | The assignment problem | 2018-01-10 13:14:50.555143+00 Awesome Compiler | | 2018-01-10 11:15:09.227063+00 | You need such a software! | 2018-01-18 12:33:58.601575+00 | Pareto Graph Contraction Algorithm | 2018-04-06 14:26:19.153304+00 | name | 2018-01-19 11:34:09.447519+00 | Formal study in Coq of pi computations using arithmetic-geometric means | 2018-04-16 09:06:17.83487+00 | My very awesome software | 2018-01-18 12:16:14.563138+00 | | 2018-07-17 15:17:57.583629+00 | Test BM | 2018-01-10 12:09:39.975391+00 Composing a Web of Audio Applications | | 2017-10-25 13:16:06.456262+00 Je suis GPL | | 2018-02-01 11:05:13.103607+00 | MyMakeFile | 2017-12-21 09:48:23.001955+00 | MailSender4Hal | 2018-01-05 12:50:40.977218+00 | Battleship exercise | 2018-03-20 10:38:26.563157+00 | Porridge, an OCaml library implementing POR techniques for checking trace equivalence of security protocols | 2018-07-02 08:37:50.948657+00 | moldableILP | 2018-03-13 14:25:10.846694+00 | BM ConvLatex pour Test Software Heritage: Sur plateforme de test | 2018-07-04 07:33:26.430386+00