albums_artists
26 rows where artist_id = 450
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 461 | 461 | 441 441 | 450 450 |
| 3431 | 3431 | 3238 3238 | 450 450 |
| 5809 | 5809 | 5542 5542 | 450 450 |
| 7306 | 7306 | 7010 7010 | 450 450 |
| 7913 | 7913 | 7597 7597 | 450 450 |
| 9812 | 9812 | 9466 9466 | 450 450 |
| 11447 | 11447 | 11110 11110 | 450 450 |
| 12690 | 12690 | 12350 12350 | 450 450 |
| 13606 | 13606 | 13255 13255 | 450 450 |
| 14508 | 14508 | 14152 14152 | 450 450 |
| 15267 | 15267 | 14922 14922 | 450 450 |
| 17270 | 17270 | 16967 16967 | 450 450 |
| 17529 | 17529 | 17235 17235 | 450 450 |
| 18710 | 18710 | 18465 18465 | 450 450 |
| 19310 | 19310 | 19092 19092 | 450 450 |
| 19668 | 19668 | 19468 19468 | 450 450 |
| 20694 | 20694 | 20533 20533 | 450 450 |
| 20695 | 20695 | 20534 20534 | 450 450 |
| 20696 | 20696 | 20535 20535 | 450 450 |
| 21821 | 21821 | 21718 21718 | 450 450 |
| 23016 | 23016 | 22920 22920 | 450 450 |
| 24063 | 24063 | 23953 23953 | 450 450 |
| 24607 | 24607 | 24485 24485 | 450 450 |
| 25698 | 25698 | 25598 25598 | 450 450 |
| 25794 | 25794 | 25695 25695 | 450 450 |
| 26027 | 26027 | 25928 25928 | 450 450 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE albums_artists ( album_id integer NOT NULL, artist_id integer NOT NULL, FOREIGN KEY(artist_id) REFERENCES artists(id), FOREIGN KEY(album_id) REFERENCES albums(id), UNIQUE(album_id, artist_id) );