albums_labels

5 rows where label_id = 541

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1021 1021 873 873 Palto Flats 541
5255 5255 4583 4583 Palto Flats 541
7851 7851 6833 6833 Palto Flats 541
9989 9989 8736 8736 Palto Flats 541
30237 30237 27248 27248 Palto Flats 541

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