albums_artists

12 rows where artist_id = 1344

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1467 1467 1383 1383 1344 1344
2633 2633 2478 2478 1344 1344
4888 4888 4661 4661 1344 1344
6143 6143 5864 5864 1344 1344
6688 6688 6397 6397 1344 1344
7498 7498 7192 7192 1344 1344
8399 8399 8073 8073 1344 1344
8400 8400 8074 8074 1344 1344
13890 13890 13533 13533 1344 1344
17685 17685 17390 17390 1344 1344
23930 23930 23817 23817 1344 1344
26701 26701 26573 26573 1344 1344

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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)
);