albums_labels

4 rows where label_id = 1464

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
4356 4356 3805 3805 MSFTS MUSIC 1464
4410 4410 3849 3849 MSFTS MUSIC 1464
6770 6770 5898 5898 MSFTS MUSIC 1464
6812 6812 5939 5939 MSFTS MUSIC 1464

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