gistfile1.txt

select id, mbid, (length/60)::text || ':' || (length%60)::text from submission where id in (select distinct submission_id from track_mbid_source where track_mbid_id =1231384);

    id    |                 mbid                 | ?column? 
----------+--------------------------------------+----------
 24884813 | 6afd8432-f56e-44b0-8331-ce62fdf408fc | 4:1
 16685155 | 06d955ce-b888-4bdc-a15f-b206a2f7ac77 | 4:3
  1504569 | 5f5335d6-9151-42a9-a3ee-b3ba756228a8 | 4:3
  2959818 | 6afd8432-f56e-44b0-8331-ce62fdf408fc | 4:1
 11888389 | 5f5335d6-9151-42a9-a3ee-b3ba756228a8 | 4:3
  8861348 | 5f5335d6-9151-42a9-a3ee-b3ba756228a8 | 4:3
 13813347 | 9f736954-28f2-49d1-b790-fcfe51a35003 | 3:59
  5989324 | 5f5335d6-9151-42a9-a3ee-b3ba756228a8 | 4:3
 24418907 | 06d955ce-b888-4bdc-a15f-b206a2f7ac77 | 4:3
  8671112 | 5f5335d6-9151-42a9-a3ee-b3ba756228a8 | 4:3
 11596224 | 9f736954-28f2-49d1-b790-fcfe51a35003 | 3:59
  1991623 | 5f5335d6-9151-42a9-a3ee-b3ba756228a8 | 3:59
 25750597 | 2f7621f2-148b-4808-af5c-4ca5bf887665 | 4:3
 24774799 | 06d955ce-b888-4bdc-a15f-b206a2f7ac77 | 4:3
 16606496 | 06d955ce-b888-4bdc-a15f-b206a2f7ac77 | 4:2
  1991137 | b5266968-fd1d-49af-a7a1-a17dbded3573 | 3:59
  9435203 | ab4adde6-913d-4ea5-abd9-ab3f5ec21b0d | 4:0
  8407167 | 5f5335d6-9151-42a9-a3ee-b3ba756228a8 | 4:3
 13436719 | 5f5335d6-9151-42a9-a3ee-b3ba756228a8 | 4:3
 17006474 | 06d955ce-b888-4bdc-a15f-b206a2f7ac77 | 4:3
  9325409 | ab4adde6-913d-4ea5-abd9-ab3f5ec21b0d | 4:2
  4115489 |                                      | 4:1
 16612079 | 06d955ce-b888-4bdc-a15f-b206a2f7ac77 | 4:2
 15697084 | 6afd8432-f56e-44b0-8331-ce62fdf408fc | 4:1
  2069178 | 5f5335d6-9151-42a9-a3ee-b3ba756228a8 | 3:59
 17133150 | 06d955ce-b888-4bdc-a15f-b206a2f7ac77 | 4:1
  6186573 |                                      | 4:5
  3332195 | 5f5335d6-9151-42a9-a3ee-b3ba756228a8 | 4:3
 22542291 | 06d955ce-b888-4bdc-a15f-b206a2f7ac77 | 4:1
  2361487 | 67ea32af-e4b1-407d-ac65-e87b34887206 | 4:2
  1502277 | 5f5335d6-9151-42a9-a3ee-b3ba756228a8 | 4:3
 16536820 | 6afd8432-f56e-44b0-8331-ce62fdf408fc | 4:1
  2464565 | 6afd8432-f56e-44b0-8331-ce62fdf408fc | 4:1
 17133241 | 06d955ce-b888-4bdc-a15f-b206a2f7ac77 | 4:3
  2521578 | 6afd8432-f56e-44b0-8331-ce62fdf408fc | 4:1
  8713394 | 5f5335d6-9151-42a9-a3ee-b3ba756228a8 | 4:3
  4117538 |                                      | 4:1
 24673953 |                                      | 4:3
 25569681 | 6afd8432-f56e-44b0-8331-ce62fdf408fc | 4:1
 24774829 | 06d955ce-b888-4bdc-a15f-b206a2f7ac77 | 4:2
 23350087 | 6afd8432-f56e-44b0-8331-ce62fdf408fc | 4:1
 22073006 | 5f5335d6-9151-42a9-a3ee-b3ba756228a8 | 4:3
 17603309 |                                      | 4:3
  4444548 |                                      | 4:2
 25509633 | 06d955ce-b888-4bdc-a15f-b206a2f7ac77 | 4:1
  2068792 | b5266968-fd1d-49af-a7a1-a17dbded3573 | 3:59
  6184516 | 6afd8432-f56e-44b0-8331-ce62fdf408fc | 4:1
 15625388 | 6afd8432-f56e-44b0-8331-ce62fdf408fc | 4:1
  2670570 | 5f5335d6-9151-42a9-a3ee-b3ba756228a8 | 4:3
  3223349 | 5f5335d6-9151-42a9-a3ee-b3ba756228a8 | 3:59
 14445890 | 06d955ce-b888-4bdc-a15f-b206a2f7ac77 | 3:59
  1509487 | 5f5335d6-9151-42a9-a3ee-b3ba756228a8 | 4:3
 15741417 | 06d955ce-b888-4bdc-a15f-b206a2f7ac77 | 4:1
 16724599 | 06d955ce-b888-4bdc-a15f-b206a2f7ac77 | 4:3
(54 rows)