albums_labels

6 rows where label_id = 561

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1055 1055 904 904 Ecstatic 561
1745 1745 1521 1521 Ecstatic 561
1952 1952 1705 1705 Ecstatic 561
3849 3849 3363 3363 Ecstatic 561
12017 12017 10519 10519 Ecstatic 561
12250 12250 10730 10730 Ecstatic 561

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE albums_labels (
	album_id integer NOT NULL,
	label_id integer NOT NULL,
	FOREIGN KEY(album_id) REFERENCES albums(id),
	FOREIGN KEY(label_id) REFERENCES labels(id),
	UNIQUE(album_id,label_id)
);