albums_labels

6 rows where label_id = 1582

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
4880 4880 4263 4263 Island 1582
4941 4941 4319 4319 Island 1582
4986 4986 4354 4354 Island 1582
5573 5573 4851 4851 Island 1582
6921 6921 6027 6027 Island 1582
7322 7322 6367 6367 Island 1582

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