Skip to content

Instantly share code, notes, and snippets.

@mayhem

mayhem/gist:afd89e024a0b5196e6b453ab941a5836

Created June 28, 2019 10:35
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mayhem/afd89e024a0b5196e6b453ab941a5836 to your computer and use it in GitHub Desktop.
Save mayhem/afd89e024a0b5196e6b453ab941a5836 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
select * from recording r join recording_json rj on r.data = rj.id where gid in ('03dd7916-fc2c-4b50-aa37-7353fd70fb4f', '9964b00c-6e64-41f2-b9c8-91a9982da27b', '6087e0a5-b57a-4194-8928-580ae388a475');
id | gid | data | artist | release | submitted | id | data | data_sha256 | meta_sha256
----------+--------------------------------------+----------+--------------------------------------+--------------------------------------+-------------------------------+----------+-----------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------+------------------------------------------------------------------
30163464 | 03dd7916-fc2c-4b50-aa37-7353fd70fb4f | 30213988 | bf4cb1ee-7a93-44d6-9463-c46063506a20 | 83c5326f-00c7-4e6b-b8d5-5cab4339d3da | 2019-05-04 15:13:58.809038+00 | 30213988 | {"title": "All Mine", "artist": "Portishead", "release": "Greatest Hits '99", "recording_mbid": "01569602-6bb4-3ecd-8981-41c7a0ca7bf7"} | 736408d8b58701290fc88a355f817fecf02131fae10ad33e07492213de254b02 | 09351f7896f1f8afbe31e023e60449d0fe90cabdc1a6140538d6de0ecab93864
30168108 | 6087e0a5-b57a-4194-8928-580ae388a475 | 30218634 | bf4cb1ee-7a93-44d6-9463-c46063506a20 | fba098b8-38d2-4af1-b6e8-cc2813d398be | 2019-05-04 15:38:20.471044+00 | 30218634 | {"title": "All Mine", "artist": "Portishead", "release": "Greatest Hits'99", "recording_mbid": "01569602-6bb4-3ecd-8981-41c7a0ca7bf7"} | cf8e919bfd30cf14fb6cb419626d5a7e012b277c9f8a5546dc9978e88adfa98d | 09351f7896f1f8afbe31e023e60449d0fe90cabdc1a6140538d6de0ecab93864
27825698 | 9964b00c-6e64-41f2-b9c8-91a9982da27b | 27864851 | bf4cb1ee-7a93-44d6-9463-c46063506a20 | | 2019-03-28 10:50:39.06389+00 | 27864851 | {"title": "All Mine", "artist": "Portishead", "recording_mbid": "01569602-6bb4-3ecd-8981-41c7a0ca7bf7"} | 86b748b96dd09f4bdb48d48ad5a9dacf903578a2c9a003344655ff140ef042e2 | 09351f7896f1f8afbe31e023e60449d0fe90cabdc1a6140538d6de0ecab93864
(3 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment